Re: Speeding up a Mysql Select

You should include a LIMIT to the sql-query or mysql parses the whole database example: SELECT * FROM support WHERE begintime > 'timestamp1' AND begintime < 'timestamp2' LIMIT 0,1'; John W. Holmes wrote:

I'm doing a select on a database that has about 45000 records and

growing

and its a bit SLOW. Its using a unix timestand to mark the beginning of a call and the end

of

a call. This is also used so I know what date the call was received. When I do a select * from support where begintime between 'timestamp1' and 'timestamp2'; It takes a while to execute... The timestamp fieldtype is

varchar(10)...

Will I see any speed difference with a different column type? Any advice on how to speed this up would be greatly appreciated! :)

It would probably help to make it an INT column, since that's what timestamps are and then index the column. Also, I've heard that it's faster to use "begintime > timestamp1 and begintime < timestamp2" instead of BETWEEN. It's probably minor, though, compared to the advantage you'll get from an indexed INT column. ---John Holmes...