[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