> 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... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
