On 17/07/2007, at 8:33 PM, K2O2 wrote: > Dear all, > > MySQL 4.0 becomes slowing down on 200000 of records on patient > visit. Especially when browsing, data of wards and its waiting list > patients. I am trying to tune the mysql Server increasing file size > and also buffer. > > Is there any one who solved the problem to make it faster Mysql > server. > > Please suggest me how to improve the speed on Mysql. As I am on > urgent, please reply me ASAP.
A slow query on 200000 records is most likely nothing to do with your buffers, but is more likely to do with a missing or misconfigured index. Check what indexes are available and being used and see what can be adjusted there to get the most benefit. Regards Jonathon ------------------------------------ Jonathon Coombes - Cybersite Consulting MySQL Consulting + Training Partner Authorised MySQL Training Centre http://www.cybersite.com.au ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
