Hello 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
Yes and no, but that's true indeed ;-) 200.000 records make really no headache for mysql. Fist you should check the suggestion of Jonathon of index. If that is okay, there is also a way of digging deeper on your mysql-server: http://dev.mysql.com/doc/refman/5.0/en/optimizing-the-server.html I have here running also mysql on other projects with billions of records and it's working extremely fast. So mysql does normally not know a frontier when it's staring of getting slower (if the tables are indexed). Maybe you could tell little bit more about your server perimeters (CPU, RAM...) Robert ------------------------------------------------------------------------- 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
