G'day, 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
