[snip] Further to my email last week, I've now indexed all the fields that get searched on (i.e. sql statement is similar to "select x, y from table where x='blah'" - x is the indexed field). Is that the correct field to index? [/snip] Yes, have you tried an EXPLAIN on your SELECT? [snip] Sorry for it being so long, but that's the table! [/snip] Have you considered the MySQL mailing list? [snip] Currently there are 1.5 million (1,500,00) records, and searching the table for the last 10 records is taking up to 40 seconds. e.g. select unixtime, type, subtype, src, dst, msg, pri from syslog where type='ips' ORDER BY unixtime DESC LIMIT 10 Does anyone have any suggestions for improving the search? [/snip] Bigger, faster hardware....really, what are you running this on? I have some tables nearing the 500,000,000 (half a billion) records mark running on multi-processor servers that do searches in under a minute. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
