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! :)

Best Regards
Bob Irwin
Server Admin & Web Programmer
Planet Netcom

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to