[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
55) NOT NULL default
'', `new_distance` varchar(255) NOT NULL default '', `new_dst` varchar(255)
NOT NULL default '', `device` varchar(255) NOT NULL default '', `distance`
varchar(255) NOT NULL default '', `icmp_id` varchar(255) NOT NULL default '',
`icmp_type` varchar
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 pages
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 carryo
4 matches
Mail list logo
