Slow ado queries on stored procedures

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

Article #2855

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

#2855

From: lyle
Date: Tue, 11 Mar 2003 23:39

9 lines
1703 bytes

Hi:

We are using a TAdoQuery object to connect to a SQL 2000 Server.  On one client application we will execute a stored procedure using the exec statement ie: "exec <procedure name>".  On a second application on the same client machine, we will execute the very same procedure.  

The mystery is that the fist client is substantially slower in all accounts.  We have traced it from the server side and there seems to be no explanation.  The connection strings look identical.  The only difference between the applications now seems to be that the slower execution times are coming from an application coming from BCB5 and the faster one from BCB6.

Does anyone have any ideas where I could look to see what may be causing the slower connection execution.

I appreciate any ideas at all.

Technical Details

Message-ID: <3e6e73c8$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,44d1810f069c6996,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-03-11 15:54:07 PST
From: "lyle" <lyle.mix@sjrb.ca>
Sender: "lyle" <lyle.mix@sjrb.ca>
Reply-To: "lyle" <lyle.mix@sjrb.ca>
Subject: Slow ado queries on stored procedures
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 204.209.209.129 204.209.209.129    
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3e6e73c8$1@newsgroups.borland.com>
Date: 11 Mar 2003 15:39:52 -0800
X-Trace: newsgroups.borland.com 1047425992 207.105.83.65 (11 Mar 2003 15:39:52 -0800)
Lines: 10
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail