RE: [PHP] Speeding up a Mysql Select
| From: | John W. Holmes | Date: | Wed, 09 Oct 2002 10:47:46 +0000 |
| Subject: | RE: [PHP] Speeding up a Mysql Select | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-119409@lists.php.net to get a copy of this message | ||
> 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...