Re: ADO Performance problems

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

Article #4542

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

#4542

From: Ron
Date: Fri, 23 Nov 2001 21:47

7 lines
1308 bytes

Thank you very much, I did not know about the ADOConnection issues with SQL
server, by creating a new ADOConnection for every Active recordset my
performance doubled and then some....  Does this rule of one open cursor per
connection restriction apply only to SQL Server or to all databases when
using ADO???

Once again, thanks so much, I really appreciate the help!

Technical Details

Message-ID: <3bfec3c8_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

References:

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

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-23 13:52:29 PST
From: "Ron" <noemailyouspammers@spamfree.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3bf579f2$1_1@dnews> <3bf5d57f.325120468@newsgroups.borland.com> <3bfae5f4$1_2@dnews> <3bfb5993.2222512@forums.inprise.com>
Subject: Re: ADO Performance problems
Date: Fri, 23 Nov 2001 14:47:13 -0700
Lines: 10
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 199.185.250.210
Message-ID: <3bfec3c8_1@dnews>
X-Trace: dnews 1006552008 199.185.250.210 (23 Nov 2001 13:46:48 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

Reply to Parent Message