Speeding up a Mysql Select
| From: | Bob Irwin | Date: | Wed, 09 Oct 2002 05:21:56 +0000 |
| Subject: | Speeding up a Mysql Select | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-119391@lists.php.net to get a copy of this message | ||
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