From: Gareth Williams [mailto:[EMAIL PROTECTED]
Sent: Fri 04/03/2005 13:17
To: James Nunnerley
Cc: php-general@lists.php.net
Subject: Re: [PHP] Improving a MySQL Search
Create some indexes. I spend most of my day messing around with a
table
[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
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 100 records.
With this amount of information, it's taking a large time to
Create some indexes. I spend most of my day messing around with a
table of 200 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
4 matches
Mail list logo