Article View: borland.public.cppbuilder.database.ado
Article #10Re: ADOConnection, ADOTable, ADOQuery Basics
From: Clayton Arends
Date: Fri, 22 Feb 2008 06:00
Date: Fri, 22 Feb 2008 06:00
31 lines
2349 bytes
2349 bytes
"Sudesh" <sudeshc@vfemail.net> wrote in message news:47be3d98@newsgroups.borland.com... > 1. any tips for fast operations and warnings about the things one > shouldn't > do. If you find yourself running select queries behind the scenes then you can take advantage of the "forward-only" cursor type. This cursor achieves better performance (when the ado driver and DBMS support it). Forward-only will *not* work with dbgrid, dbnavigator, etc. Set the CacheSize property to something reasonable like 1024. This reduces the number of round trips to retrieve your data. As for what *not* to do I don't really have any tips. Once you play with ADO for a little bit you will discover what its limitations are. > 2. any guidelines in operating in Client/Server mode. Sorry, if you have specific questions then I can try to help you. > 3. can you point me a good reference weblink/source for general database > information. Again, sorry. I get most of my information via web searches or by just playing around. I will occassionally come across a good reference but I haven't bookmarked any. Happy coding, Clayton
Technical Details
Message-ID:
<47be651a$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<47b97333@newsgroups.borland.com> <47bda663$1@newsgroups.borland.com> <47bdc08c@newsgroups.borland.com> <47bde596$1@newsgroups.borland.com> <47be3d98@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,a49b6386b1d150d4 X-Google-Attributes: gid10698b,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit From: "Clayton Arends" <nospam_claytonarends@hotmail.com> Newsgroups: borland.public.cppbuilder.database.ado References: <47b97333@newsgroups.borland.com> <47bda663$1@newsgroups.borland.com> <47bdc08c@newsgroups.borland.com> <47bde596$1@newsgroups.borland.com> <47be3d98@newsgroups.borland.com> In-Reply-To: <47be3d98@newsgroups.borland.com> Subject: Re: ADOConnection, ADOTable, ADOQuery Basics Date: Thu, 21 Feb 2008 22:00:50 -0800 Lines: 32 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Windows Mail 6.0.6000.16480 X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16545 NNTP-Posting-Host: 68.185.45.89 Message-ID: <47be651a$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1203660058 68.185.45.89 (21 Feb 2008 22:00:58 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail