Re: ADO Performance problems

Article View: borland.public.cppbuilder.database.ado

Article #4544

Back to borland.public.cppbuilder.database.ado Previous Next

#4544

From: Matt Jacobs
Date: Sat, 24 Nov 2001 10:15

16 lines
1530 bytes

You're welcome. AFAIK, it's only an issue with SQL Server and only
applies to server-side, forward-only cursors. These are commonly
called "firehose" cursors.

You should not have to create a new connection per recordset if you
are not using firehose cursors. The best way is to share a single
connection object with all your ADO tables and queries, and as long as
you avoid firehose cursors, you should be okay.



--

My reply-to address is purposely mangled to thwart auto-reply bots. 
Please remove the two leading underscores if you wish to reply via
e-mail.

Technical Details

Message-ID: <3bff726c.792243@forums.inprise.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.mesh.ad.jp!uunet!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

References:

<3bf579f2$1_1@dnews> <3bf5d57f.325120468@newsgroups.borland.com> <3bfae5f4$1_2@dnews> <3bfb5993.2222512@forums.inprise.com> <3bfec3c8_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,9defb43ff18ceee2
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-11-24 02:28:50 PST
From: mattja@ix.netcom.com (Matt Jacobs)
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: ADO Performance problems
Date: Sat, 24 Nov 2001 10:15:56 GMT
Reply-To: __mattja@ix.netcom.com
Message-ID: <3bff726c.792243@forums.inprise.com>
References: <3bf579f2$1_1@dnews> <3bf5d57f.325120468@newsgroups.borland.com> <3bfae5f4$1_2@dnews> <3bfb5993.2222512@forums.inprise.com> <3bfec3c8_1@dnews>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: 24.254.59.80
X-Trace: dnews 1006596836 24.254.59.80 (24 Nov 2001 02:13:56 -0800)
Lines: 16
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.mesh.ad.jp!uunet!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Reply to Parent Message