Article View: borland.public.cppbuilder.database.ado
Article #2865Re: Slow ado queries on stored procedures
From: Lyle
Date: Wed, 12 Mar 2003 15:00
Date: Wed, 12 Mar 2003 15:00
28 lines
1963 bytes
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-mailReferences:
<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