🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Slow ado queries on stored procedures

#2865
From: Lyle
Date: Wed, 12 Mar 2003 15:00
28 lines
1963 bytes
In addition to below... 

We have now tried BCB5 to compile a simple BCB5 client that
makes the same calls.  They are the same as the original
BCB6 client. 

"lyle" <lyle.mix@sjrb.ca> wrote:

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: <3e6f4b74$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <3e6e73c8$1@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,44d1810f069c6996
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-03-12 07:12:02 PST
From: "Lyle" <lyle.mix@sjrb.ca>
Sender: "Lyle" <lyle.mix@sjrb.ca>
Reply-To: "Lyle" <lyle.mix@sjrb.ca>
Subject: Re: Slow ado queries on stored procedures
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 204.209.209.129 204.209.209.129    
References:  <3e6e73c8$1@newsgroups.borland.com>
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3e6f4b74$1@newsgroups.borland.com>
Date: 12 Mar 2003 07:00:04 -0800
X-Trace: newsgroups.borland.com 1047481204 207.105.83.65 (12 Mar 2003 07:00:04 -0800)
Lines: 29
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail