Thursday, March 29, 2012

DRINK WATER ON EMPTY STOMACH



It is popular in Japan today to drink water immediately after waking up every morning. Furthermore, scientific tests have proven its value. We publish below a description of use of water for our readers. For old and serious diseases as well as modern illnesses the water treatment had been found successful by a Japanese medical society as a 100% cure for the following diseases:
Headache, body ache, heart system, arthritis, fast heart beat, epilepsy, excess fatness, bronchitis asthma, TB, meningitis, kidney and urine diseases, vomiting, gastritis, diarrhea, piles, diabetes, constipation, all eye diseases, womb, cancer and menstrual disorders, ear nose and throat diseases.
METHOD OF TREATMENT
1. As you wake up in the morning before brushing teeth, drink 4 x 160ml glasses of water
2. Brush and clean the mouth but do not eat or drink anything for 45 minute
3.. After 45 minutes you may eat and drink as normal.
4. After 15 minutes of breakfast, lunch and dinner do not eat or drink anything for 2 hours
5. Those who are old or sick and are unable to drink 4 glasses of water at the beginning may commence by taking little water and gradually increase it to 4 glasses per day.
6. The above method of treatment will cure diseases of the sick and others can enjoy a healthy life.
The following list gives the number of days of treatment required to cure/control/reduce main diseases:
1. High Blood Pressure (30 days)
2. Gastric (10 days)
3. Diabetes (30 days)
4. Constipation (10 days)
5. Cancer (180 days)
6. TB (90 days)
7. Arthritis patients should follow the above treatment only for 3 days in the 1st week, and from 2nd week onwards – daily..
This treatment method has no side effects, however at the commencement of treatment you may have to urinate a few times.
It is better if we continue this and make this procedure as a routine work in our life. Drink Water and Stay healthy and Active.
This makes sense .. The Chinese and Japanese drink hot tea with their meals ..not cold water. Maybe it is time we adopt their drinking habit while eating!!! Nothing to lose, everything to gain...
For those who like to drink cold water, this article is applicable to you.
It is nice to have a cup of cold drink after a meal. However, the cold water will solidify the oily stuff that you have just consumed. It will slow down the digestion.
Once this 'sludge' reacts with the acid, it will break down and be absorbed by the intestine faster than the solid food. It will line the intestine.
Very soon, this will turn into fats and lead to cancer. It is best to drink hot soup or warm water after a meal.

A serious note about heart attacks:
· Women should know that not every heart attack symptom is going to be the left arm hurting,
· Be aware of intense pain in the jaw line.
· You may never have the first chest pain during the course of a heart attack.
· Nausea and intense sweating are also common symptoms.
· 60% of people who have a heart attack while they are asleep do not wake up.
· Pain in the jaw can wake you from a sound sleep. Let's be careful and be aware. The more we know, the better chance we could survive...
A cardiologist says if everyone who gets this mail sends it to everyone they know, you can be sure that we'll save at least one life.
Please be a true friend and send this article to all your friends you care about

SQL Query Optimization

Sql Statements are used to retrieve data from the database. We can get same results by writing different sql queries. But use of the best query is important when performance is considered. So you need to sql query tuning based on the requirement. Here is the list of queries which we use reqularly and how these sql queries can be optimized for better performance.



SQL Tuning/SQL Optimization Techniques:

1) The sql query becomes faster if you use the actual columns names in SELECT statement instead of than '*'.
For Example: Write the query as
SELECT id, first_name, last_name, age, subject FROM student_details;
Instead of:
SELECT * FROM student_details;

2) HAVING clause is used to filter the rows after all the rows are selected. It is just like a filter. Do not use HAVING clause for any other purposes.
For Example: Write the query as
SELECT subject, count(subject) 
FROM student_details 
WHERE subject != 'Science' 
AND subject != 'Maths' 
GROUP BY subject;
Instead of:
SELECT subject, count(subject) 
FROM student_details 
GROUP BY subject 
HAVING subject!= 'Vancouver' AND subject!= 'Toronto';

3) Sometimes you may have more than one subqueries in your main query. Try to minimize the number of subquery block in your query.
For Example: Write the query as
SELECT name 
FROM employee 
WHERE (salary, age ) = (SELECT MAX (salary), MAX (age) 
FROM employee_details) 
AND dept = 'Electronics'; 
Instead of:
SELECT name 
FROM employee
WHERE salary = (SELECT MAX(salary) FROM employee_details) 
AND age = (SELECT MAX(age) FROM employee_details) 
AND emp_dept = 'Electronics';

4) Use operator EXISTS, IN and table joins appropriately in your query.
a) Usually IN has the slowest performance.
b) IN is efficient when most of the filter criteria is in the sub-query.
c) EXISTS is efficient when most of the filter criteria is in the main query.
For Example: Write the query as
Select * from product p 
where EXISTS (select * from order_items o 
where o.product_id = p.product_id)
Instead of:
Select * from product p 
where product_id IN 
(select product_id from order_items

5) Use EXISTS instead of DISTINCT when using joins which involves tables having one-to-many relationship.
For Example: Write the query as
SELECT d.dept_id, d.dept 
FROM dept d 
WHERE EXISTS ( SELECT 'X' FROM employee e WHERE e.dept = d.dept);
Instead of:
SELECT DISTINCT d.dept_id, d.dept 
FROM dept d,employee e 
WHERE e.dept = e.dept;

6) Try to use UNION ALL in place of UNION.
For Example: Write the query as
SELECT id, first_name 
FROM student_details_class10 
UNION ALL 
SELECT id, first_name 
FROM sports_team;
Instead of:
SELECT id, first_name, subject 
FROM student_details_class10 
UNION 
SELECT id, first_name 
FROM sports_team;

7) Be careful while using conditions in WHERE clause.
For Example: Write the query as
SELECT id, first_name, age FROM student_details WHERE age > 10;
Instead of:
SELECT id, first_name, age FROM student_details WHERE age != 10;
Write the query as
SELECT id, first_name, age 
FROM student_details 
WHERE first_name LIKE 'Chan%';
Instead of:
SELECT id, first_name, age 
FROM student_details 
WHERE SUBSTR(first_name,1,3) = 'Cha';
Write the query as
SELECT id, first_name, age 
FROM student_details 
WHERE first_name LIKE NVL ( :name, '%');
Instead of:
SELECT id, first_name, age 
FROM student_details 
WHERE first_name = NVL ( :name, first_name);
Write the query as
SELECT product_id, product_name 
FROM product 
WHERE unit_price BETWEEN MAX(unit_price) and MIN(unit_price)
Instead of:
SELECT product_id, product_name 
FROM product 
WHERE unit_price >= MAX(unit_price) 
and unit_price <= MIN(unit_price)
Write the query as
SELECT id, name, salary 
FROM employee 
WHERE dept = 'Electronics' 
AND location = 'Bangalore';
Instead of:
SELECT id, name, salary 
FROM employee 
WHERE dept || location= 'ElectronicsBangalore';
Use non-column expression on one side of the query because it will be processed earlier.
Write the query as
SELECT id, name, salary 
FROM employee 
WHERE salary < 25000;
Instead of:
SELECT id, name, salary 
FROM employee 
WHERE salary + 10000 < 35000;
Write the query as
SELECT id, first_name, age 
FROM student_details 
WHERE age > 10;
Instead of:
SELECT id, first_name, age 
FROM student_details 
WHERE age NOT = 10;
8) Use DECODE to avoid the scanning of same rows or joining the same table repetitively. DECODE can also be made used in place of GROUP BY or ORDER BY clause.
For Example: Write the query as
SELECT id FROM employee 
WHERE name LIKE 'Ramesh%' 
and location = 'Bangalore';
Instead of:
SELECT DECODE(location,'Bangalore',id,NULL) id FROM employee 
WHERE name LIKE 'Ramesh%';
9) To store large binary objects, first place them in the file system and add the file path in the database.
10) To write queries which provide efficient performance follow the general SQL standard rules.
a) Use single case for all SQL verbs
b) Begin all SQL verbs on a new line
c) Separate all words with a single space
d) Right or left aligning verbs within the initial SQL verb

Tuesday, March 27, 2012

History of Dindigul and Dindigul Fort


Dindigul, headquarters of the district, is in the middle of an extensive plain of red soil surrounded by hills: on the east by Aiyalur and Karandamalai hills, on the south by the Sirumalai and on the west by the lower Palani hills.

The nomenclature of the word ‘Dindigul’ is derived from the great isolated rock 380 metres above the sea level. The wedge-shaped rock, situated at the western flank of the town, is called ‘Dindu-Kal’ meaning “pillow rock’ from its resemblance to a pillow. The combination of the two Tamil words ‘Dindu’ and ‘Kal’ gave the name Dindigul to the town. In fact, inscriptions mention the word ‘Dindigul.’There is a fortress built upon it which looks like a crown adding beauty to this great rock and the place around it. It was the capital of a vast province of eighteen palaiyams under Visvanatha Nayaka (c.1529-1564 A.D.) covering the present day taluks of Vedasandur, Nilakottai, Uttamapalaiyam,Palani and Periyakulam.

The Dindigul fort is believed to have been built by Muthu Krishnappa Nayaka of Madurai (1601-1609 A.D.) On the top of the hill is a dilapidated temple dedicated to Abhiramiamman which might have been built by him. It is believed to have been originally a Siva temple,dedicated to Lord Padamagiriswara,built by the Pandyas whose architecture it resembles. The assumption may be correct. An inscription of Achyuta Deva Raya (1529-1542.A.D.) of Vijayanagar, dated 1538, recording the gift of money to the temple, appears on the wall of the Goddess Abhiramiamman temple. Similarly, a fragmentary inscription of (Konerimaikondan) Pandya period, denoting lands, appears on the walls of the Siva temple.

The walls of the fort are made of brick and stone and run round the crest of the whole rock except in the southern side which is so perpendicular that rendered artificial protection unnecessary. Tipu Sultan removed the statue of Abhiramiamman to the town in order to prevent the spies from entering the fortress.

On the south western side of the rock, close to the west corner of the fort, there is a cave 60 metre long 6 metre broad and 1 metre high. It contains rock-cut beds resembling to the Jain- caves of Thiruparankundram. The Pandya inscription on the Siva shrine attests to the presence of Jains in Dindigul.

Syed Sahib, brother-law-of Tipu Sultan, altered and improved the fort in the modern style when he was in charge of the Dindigul province from 1784-1790 A.D. The British innovated and systematically strengthened in the years 1797 and 1798. The buildings on the submit were established as prison and arsenal for military stores and it was well provided with guns. The garrison that stationed in the fort was totally dismantled in the year 1811 owing to a malignant and epidemic fever that raged in the southern province towards the end of 1810.

Medicinal Knowledge of Valaiyans in Karandamalai hills near Dindigul District, Tamilnadu, India


The Valaiyans of Karandamalai hills are blessed with rich ethnobotanical knowledge. Unfortunately, however, this knowledge is disappearing rapidly due to modernization and an uninterested youthful generation. This calls for immediate proper documentation of the fast-eroding traditional health practices of Valaiyans in order to save their vast knowledge from being lost for ever. Some of the details of different herbs used as medicine: 

Adenia wightiana (Wall. ex Wight & Arn.) Eng. (Passifloraceae); ‘Perum kurattai’ (RKM -1093)10ml of filtered juice of tuber is administered to cure peptic ulcers.

Albizia odoratissima (L.f.) Benth. (Mimosaceae); Karu vagai’ (RKM-1030); Bark paste is applied on wounds.

Alseodaphne semicarpifolia Nees (Lauraceae); Vandukadi maram’ (RKM-1045); Leaf and bark paste is applied on the region of beetle and scorpion stings

Andrographis alata (VahlNees (Acanthaceae); Periyanangai’ (RKM-1100); A handful of fresh leaves is taken orally for snakebite.

Anisochilus carnosus (L.f.) Wall. ex Benth. (Lamiaceae); Karpooravalli’ (RKM-1199); Leaf juice is given orally for digestion, cold and cough.

Aphanamixis polystachya  (Wall.) parker (Meliaceae); Vella kongu’ (RKM-1085); Oil extracted from the seed is used to treat skin diseases, especially eczema.

Aristolochia indica L. (Aristolochiaceae); Thalaisuruli’ (RKM-1163); The juice of the root is given for poisonous bites.

Artocarpus hirsutus Lam. (Moraceae); Kattupala’ (RKM-1097); Fruits used as an appetizer. Also, the powdered seed is mixed with honey and used in the treatment of asthma.

Asparagus racemosus Willd. (Asparagaceae); Thaneervittan kizhangu’ (RKM-1070)The juice of the root is given as a remedy for diarrhea, and the root paste mixed with milk is given to women for inducing lactation.

Atalantia monophylla (L.) Correa (Rutaceae); Kattuelumichai’ (RKM-1237); Fruit juice mixed with honey is given to cure cough.

Baccopa monnieri (L.) Pennel. (Scrophulariaceae); Neerbirami’ (RKM-1024); Leaves used to cure dysentery and improve the memory power.

Caesalpinia bonduc (L.) Roxb. (Caesalpiniaceae); Kachaikai’ (RKM-1229); Dried seed powder is mixed with hot milk and given for the relief of flatulence.

Cardiospermum canescens Wall. (Sapindaceae); Mudakathan’ (RKM-1010); Juice prepared from 10grams of leaves with 50ml of water is taken orally on an empty stomach for a period of  2 days in a single dose to arrest dysentery.

Celastrus paniculatus Willd. (Celastraceae); Valuluvai’ (RKM-1140); A decoction of the bark is given orally on an empty stomach for a period of 7 days to women for the purposes of abortion.

Centella asiatica (L.) Urban (Apiaceae); Vallarai’ (RKM-1227); Whole plant is used to cure dysentery and leaves are used to improve the memory power.

Cippadessa baccifera (Roth) Miq. (Meliaceae); Semmanai’ (RKM-1165); 50ml of leaf juice is taken orally to arrest dysentery.

Cissus vitiginea L. (Vitaceae); Nai thiratchai’ (RKM-1208); 10ml of the filtered juice of the fruits are mixed with the juice of Anisomeles indica (L.) Kuntze (LamiaceaePei thumbai’ ) for relief of flatulence.

Colocasia esculenta (L.) Schott. (Araceae); Seman kizhangu’ (RKM-1034); Boiled root tubers are cooked and consumed for a period of 10days to cure piles

Corallocarpus epigaeus (Rottler) C. B. Clarke (Cucurbitaceae); Kollankovai’ (RKM-1014); Paste of tuberous root applied on swellings and poisonous stings.

Curculigo orchioides Gaertn. (Hypoxidaceae); Nilapanai’ (RKM-1231); The dried rhizome powder is mixed with honey and given to males to improve semen production.    

Dioscorea hispida Denst. (Dioscoreaceae);‘Viral-valli kizhangu’ (RKM-1029);  Boiled tubers are taken twice a day for 15 days to cure piles.

Dioscorea oppostifolia L. (Dioscoreaceae); Valli kizhangu’ (RKM-1085); Boiled root tubers are taken orally to reduce body heat.

Diospyros montana Roxb. (Ebenaceae); Vakanathi’ (RKM-1095); 15-20gram of bark is crushed with 1 cup of curd and given twice a day for 3days for dysentery.

Diplocyclos palmatus (L.) C. Jeffrey (Cucurbitaceae); Sivankodi’ (RKM-1077); 50ml of leaf juice is given for 3days for fever.

Ehretia laevis Roxb. (Cordiaceae); Paakupattai’ (RKM-1039); Bark paste is applied as an ointment for cuts and wounds.

Endostemon viscosus (Roth) M. Ashby. (Lamiaceae); Senthulasi’ (RKM-1099); Leaf juice is applied externally to repel ticks.

Erythrina suberosa Roxb. (Fabaceae)Kattumulmurungai’ (RKM-1088); The leaf juice is taken orally to treat cough.

Euphorbia nivulia Buch.-Ham. (Euphorbiaceae); Illaikalli’ (RKM-1033); The milky latex is applied to purge pimples of the face.

Ficus dalhousiae Miq. (Moraceae) Kalitchi’ (RKM-1120) Bark paste is applied externally to mend cracks in the feet.

Ficus mollis Vahl. (Moraceae) Kalarasu’ (RKM-1099) Bark paste is applied as an ointment for cuts and wounds.

Gardenia resinifera Roth (Rubiaceae) Pisinotti’ (RKM-1087) The mixture of resin and sugar in hot milk is used to arrest diarrhoea.

Garuga pinnata Roxb. (Burseraceae); Karuvembu’ (RKM-1122);  Latex mixed with honey is given once a day for 2days for cough.

Gymnema sylvestre (Retz.) R. Br. ex Roemer  & Schultes; Sirukurinjan’ (RKM-1089); Two teaspoons of dried leaf powder is mixed with hot milk and given once a day for 30 days for diabetes.

Hemidesmus indicus (L.) R. Br. var. indicus. (Asclepiadaceae); Nanari’ (RKM-1025);    Leaf paste mixed with oil of Azadirachta indica A. Juss. (Meliaceae; Vembu’ ) is applied for eczema.

Henckelia incana (VahlSpreng. (Gesneriaceae); Kalthamarai’ (RKM-1253); Leaf is ground in water and the juice is taken orally to treat fever.

Holorrhena pubescens (Buch.-Ham.) (Apocynaceae); Palai’ (RKM-1059); 50ml of bark decoction is taken orally in empty stomach for dysentery.  

Hybanthus enneaspermus (L.) F. Muell. (Violaceae); Orithalthamarai’ (RKM-1030);    Leaf juice mixed with honey is given to men to enhance their sexual vigor.

Hydnocarpus wightiana (Buch.-Ham.) Oken (Flacourtiaceae); Maravettai’ (RKM-1094);  Oil extracted from the seed is applied externally for joint pains.

Ipomoea staphylina Roemer & Schult. (Convolvulaceae); Onankodi’ (RKM-1020);    Decoction of leaves and bark is given to get relief from stomach disorders.

Jatropha villosa Wight (Euphorbiaceae); Thanakan’ (RKM-1207); Latex used to cure mouth ulcer.

Kleinia grandiflora (DC.) N. Rani (Asteraceae); Muyalkathilai’ (RKM-1193)A few drops of leaf juice is poured into the ear to treat earache.

Lantana wightiana Wall. ex Gamble (Verbenaceae); ‘Vellaunni’ (RKM-1060); Leaf juice is given to children before food for easy digestion.

Marsdenia brunoniana Wight & Arn. (Asclepiadaceae); Perunkurinjan’ (RKM-1175);   Leaves dried in shade andleaf  powder is taken for diabetes.

Memecylon umbellatum Burm. f. (Melastomataceae); Kayambu’ (RKM-1105); Leaves are used to depress the appetite. 

Mitracarpus villosus (Sw.) DC. (Rubiaceae); Kayapoondu’ (RKM-1170); Leaf paste is applied externally to treat wounds.

Momordica dioica Roxb. ex Willd. (Cucurbitaceae); Naripagal’ (RKM-1120); Tuberous root is ground in hot water and 50ml of the juice is taken orally once a day on an empty stomach for 10 days to treat diabetes.

Ophiorrhiza mungos L. (Rubiaceae); Pambupoo’ (RKM-1092); Root juice is given as an antidote for snakebite.

Phyllanthus amarus Schumach. & Thonn. (Phyllanthaceae); Kellanelli’ (RKM-1101);   The juice extracted from the whole plant is taken orally once a day for 7days to treat Jaundice. Diet: Avoid salt, tamarind and chilli till recovery.

Phyllanthus indofischeri Bennet (Phyllanthaceae); Nelli’ (RKM-1147); A handful of tender leaves mixed with honey is given to children to arrest dysentery.

Psidium guajava L. (Myrtaceae); Koyya’ (RKM-1044); Tender leaf is ground and mixed with cow milk to get relief from stomachache.

Pterospermum suberifolium Lam. (Sterculiaceae); Polavu’ (RKM-1266); A handful of leaves mixed with the stem bark of Drypetes roxburghii (Wall.) Hurus (PutranjivaceaePilla maram), a few leaves of Blepharismaderaspatensis (L.) B. Heyne (AcanthaceaeElumbu otti) and the yellow yolks of 2 eggs ground into a fine paste is applied on  fractured bones.

Rhinacanthus nasutus (L.) Kurz (Acanthaceae); ‘Nagamalli’ (RKM-1048); A handful of fresh leaves is taken orally for snake bite.

Sarcostemma intermedium Decne. (Asclepiadaceae); Kodi kalli’ (RKM-1097); 5-6 drops of latex is applied externally in the spot of an insect bite.

Schleichera oleosa (Lour.) Oken (Sapindaceae); ‘Kusam or poovan’ (RKM-1139); Seed powder is mixed with water and given to cattle for removing worms from the stomach.

Semecarpus anacardium L. f. (Anacardiaceae); Serankotai’ (RKM-1069); Fruits ground with curd is applied on bald patches of the scalp to regain hair.

Solanum erianthum D. Don (Solanaceae); Sundai’ (RKM-1122); Juice of tender leaf is taken orally to arrest dysentery.

Spondias pinnata (L. f. ) Kurz (Anacardiaceae); Puli mangai’ (RKM-1090)A decoction of bark is given orally to treat stomach problems.

Strychnos nux-vomica L. (Loganiaceae); Etti’ (RKM-1177) Leaf juice is given to livestock to eliminate worms in the stomach.

Terminalia bellerica (Gaertn.) Roxb. (Combretaceae); Thandri’ (RKM-1130); The seed powder is mixed with hot water and given for stomach disorders.

Terminalia chebula Retz. (Combretaceae); Kadukai’ (RKM-1174); A teaspoon of dried fruit powder mixed with a pinch of sodium chloride is given to arrest dysentery.

Tragia involucrata L. (Euphorbiaceae); Senthatti’ (RKM-1062); The juice of the root is taken orally to get relief from constipation.

Vernonia anthelmintica (L.) Willd. (Asteraceae); Kattuseeragam’ (RKM-1015); The seeds are boiled with water and taken orally to prevent white discharge in women.

Wrightia tinctoria (Roxb.) R. Br. (Apocynaceae); Vetpalai’ (RKM-1225); Leaf paste is applied on aching teeth to get relief from toothache.