Re: Improving a MySQL Search

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




Create some indexes. I spend most of my day messing around with a table of 2000000 records, and indexes increased the speed from 40 seconds to 55 minutes for a query, down to the longest being less than 5 seconds.



On 28 Feb 2005, at 16:42, James Nunnerley wrote:

I'm creating a serious of pages that show various aspects from a Syslog
output.

The main information is currently stored in one MySQL table - which after
having been run for about 2 and a bit months has got nearly 1000000 records.
With this amount of information, it's taking a large time to carryout even
the simplest query.




Someone has suggested I look at setting up an archive, for slower searches,
and a more recent table for quicker searching, but I'm reluctant to do this,
as it would take quite a bit of time to copy all the information across as
it stands, and then also to run a cron which transfers between the live and
archive.




Can anyone suggest some quick easy methods for speeding up the search?



Cheers

James


-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux