Also, probably a stupid question, but, is the `begintime` column
indexed? If it isn't, no matter what you do, the whole thing will keep
getting slower at an alarmingly fast pace :)
Marco
On Wed, 2002-10-09 at 07:14, Maurits Lawende wrote:
> You should include a LIMIT to the sql-query or mysql
You should include a LIMIT to the sql-query or mysql parses the whole
database
example:
SELECT * FROM `support` WHERE `begintime` > 'timestamp1' AND
`begintime` < 'timestamp2' LIMIT 0,1';
John W. Holmes wrote:
>>I'm doing a select on a database that has about 45000 records and
>>
>>
>gr
> 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 whe
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
4 matches
Mail list logo