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
3 matches
Mail list logo