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

John Handelaar genghis at members.evolt.org
Tue Jul 23 17:45:14 CDT 2002


> -----Original Message-----
> From: theforum-admin at lists.evolt.org
> [mailto:theforum-admin at lists.evolt.org]On Behalf Of John Handelaar
> Sent: 23 July 2002 23:39
> To: theforum at lists.evolt.org
> Subject: RE: [Theforum] [---Dev] RE: [---tent] Article cleanup issue

Replying to self, apologies

> 4.  To get your total (if it's required, but that's another story),
>     I'd suggest a better approach would be to run a second query
>     a la MySQL's SELECT COUNT(*) FROM stories, which is lightning
>     fast and returns only one row as a result.

I see Jeff's point about opening and closing DB connections
but I'd be surprised (honest) if we actually were opening
and closing same on each query, rather than using persistent
connections.  Certainly if we're not, we should be :-)

Also another question - is it a direct connection or does
CF use ODBC?

------------------------------------------
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