Re: When to set Prepared = true

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

Article #4881

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

#4881

From: Mark Cashman
Date: Fri, 24 Aug 2001 11:11

15 lines
1532 bytes

Hi, Matt!

Preparing the query confers no real benefits if you are only executing
the query once. It basically invokes a SQL parser so that the parsing
step does not need to be reexecuted each time the parameters are changed
or each time the query is refreshed with Close() / Open()

------
Mark Cashman (TeamB - C++ Builder), creator of The Temporal Doorway at
http://www.temporaldoorway.com
- Original digital art, writing, music and more -
C++ Builder / JBuilder Tips and The C++ Builder Programmer's Webring
(Join us!)
http://www.temporaldoorway.com/programming/index.htm
------

Technical Details

Message-ID: <3B863647.F5E35CC4@temporaldoorway.com>

Path:

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

References: <3b85f5e5.1283054@forums.inprise.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,2c35ed6da94cb5e6
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-08-24 04:15:38 PST
Message-ID: <3B863647.F5E35CC4@temporaldoorway.com>
Date: Fri, 24 Aug 2001 07:11:03 -0400
From: Mark Cashman <mcashman@temporaldoorway.com>
Reply-To: mcashman@temporaldoorway.com
X-Mailer: Mozilla 4.77 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: When to set Prepared = true
References: <3b85f5e5.1283054@forums.inprise.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 24.14.197.193
X-Trace: dnews 998651671 24.14.197.193 (24 Aug 2001 04:14:31 -0700)
Lines: 17
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!howland.erols.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

Reply to Parent Message