TADOStoredProc takes a long time

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

Article #94

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

#94

From: Matthias Schuppe
Date: Tue, 31 Jul 2007 07:35

10 lines
1468 bytes

Hi,

  by ADO Components I access an MS SQL Server 2005 Database. There ist
a stored procedure where execution takes 200 ms in SQL Server
Management Studio.

  If I call the same procedure in TADOStoredProc it takes five seconds
or more. Does anybody have an idea to this?

Matthias

Technical Details

Message-ID: <1185867359.597850.119820@l70g2000hse.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!l70g2000hse.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,9248711042bd7250,start
X-Google-Attributes: gid10698b,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!l70g2000hse.googlegroups.com!not-for-mail
From:  Matthias Schuppe <matthias2378@gmx.net>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: TADOStoredProc takes a long time
Date: Tue, 31 Jul 2007 00:35:59 -0700
Organization: http://groups.google.com
Lines: 11
Message-ID: <1185867359.597850.119820@l70g2000hse.googlegroups.com>
NNTP-Posting-Host: 82.210.249.4
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1185867359 24717 127.0.0.1 (31 Jul 2007 07:35:59 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 31 Jul 2007 07:35:59 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.5) Gecko/20070713 Firefox/2.0.0.5,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 netcache02 (NetCache NetApp/6.0.6)
Complaints-To: groups-abuse@google.com
Injection-Info: l70g2000hse.googlegroups.com; posting-host=82.210.249.4;
   posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0