vaskar

Hi ALL, When i run this query it's take too much time to execute. SELECT ptnt.*,ptntF.familyName FROM -> (SELECT ptntPatientDetails.*,ptntPatientDetailsLang.occupation,ptntPatientDetailsLang.notes,pracStatusMasterLang.statusDesc, -> IFNULL((select countryName from genCountry where ice_global.genCountry.countryID = ptntPatientDetails.country),'') as countryName, -> IFNULL((select stateName from genState where ice_global.genState.stateID = ptntPatientDetails.state),'') as stateName -> FROM ptntPatientDetails,ptntPatientDetailsLang,pracStatusMasterLang -> WHERE ptntPatientDetails.patientID = ptntPatientDetailsLang.ptntPatientID …

Hi All, why do we need filter in a servlet? When we use servlet filter? pls help me thanks!

I used both Myisam and InnoDB. We have something like 500k update, 500k and 500k insert/delete/replace per hour. Many full scan because of updation.Both give me some problem either dead lock occurs or too many connection rise. Also insert/delete/replace operation takes long time. If i used innodb then dead lock …