[Theforum] [---Dev] RE: [---tent] Article cleanup issue

.jeff jeff at members.evolt.org
Tue Jul 23 16:27:20 CDT 2002


> From: John Handelaar
> > fwiw, querying for 800 records
> > should be cake and should *not* be the issue here.
> Querying through 800 records is one thing.  The query
> *returning* 800 records is quite another and should not
> be happening.

i'd like to restate *again* that returning the 800 records to coldfusion is *not*, i repeat *not*, the issue here.  this is clearly illustrated by the comment search being able to return over 2800 records in under 6000ms.  so, it's clearly not an issue with how many records.  it's more likely an issue with things like indexes (though i thought those were all in place), sql syntax (which can't really be much more efficient and still gather all the necessary info), or the actual size of the data that's being returned in the resultset.

how would you go about accomplishing the querying and still retain the existing functionality?  ie, return the most recent 10 articles, give the user a way of knowing how many total available pages to browse though, and the ability to browser to them.  please be as detailed as possible -- i wouldn't want to miss anything.


jeff at members.evolt.org

More information about the theforum mailing list