Make sure the query has an "order by". I swear I found not having an "order by" changed a query of 400,000 customers in a mysql system from 2 minutes to 10 seconds once. Never looked into it thoroughly as I very seldom have that concern. For certain, there are always more and less efficient ways to construct queries and which to use can sometimes be influenced by the number of records. Sometimes a single more complicated query is less efficient or unusable while extracting part of the query and using it in a separate query works great.
Steve
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jonathon Coombes
Sent: Tuesday, July 17, 2007 6:45 AM
To: care2002-developers@lists.sourceforge.net
Subject: Re: [Care2002-developers] mysql tuning !
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
-------------------------------------------------------------------------
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.
_______________________________________________
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.10.8/904 - Release Date: 7/16/2007 5:42 PM
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.10.8/904 - Release Date: 7/16/2007 5:42 PM
------------------------------------------------------------------------- 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
