[Theforum] [---Dev] RE: [---tent] Article cleanup issue
John Handelaar
genghis at members.evolt.org
Tue Jul 23 15:35:12 CDT 2002
> -----Original Message-----
> From: theforum-admin at lists.evolt.org
> [mailto:theforum-admin at lists.evolt.org]On Behalf Of .jeff
> Sent: 23 July 2002 20:48
> To: theforum at lists.evolt.org
> Subject: RE: [Theforum] [---Dev] RE: [---tent] Article cleanup issue
>
> the performance problem is bad enough that a resultset of 800
> causes the initial hit to the database to take between 7000 and
> 10000 ms to return the resultset.
Why on earth does the query to generate the front page
return a result set of 800 records?
How about indexing, or LIMIT?
------------------------------------------
John Handelaar
T +44 20 8933 1494 M +44 7930 681789
F +44 870 169 7657 E john at userfrenzy.com
------------------------------------------
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.375 / Virus Database: 210 - Release Date: 10/07/2002
More information about the theforum
mailing list