Article View: borland.public.cppbuilder.database.ado
Article #4972Re: Performance info on different data access options?
From: Mark Cashman
Date: Mon, 10 Sep 2001 23:32
Date: Mon, 10 Sep 2001 23:32
17 lines
1704 bytes
1704 bytes
Hi, Jeff! Database performance on inserts can be affected by a number of factors. For instance, not using indexes makes inserts faster. If you can do the inserts asynchronously, you could simply write them to a socket and have a separate program do the inserts. If you can dedicate a separate machine, you could use the socket to talk to another machine or you could use a more advanced capability like a remote data module. ------ 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:
<3B9D4D8B.B5F6241A@temporaldoorway.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!sn-xit-03!supernews.com!logbridge.uoregon.edu!news.maxwell.syr.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsReferences:
<3b9c387a$1_2@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,f478b54d3bc0b92a X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-09-10 16:36:48 PST Message-ID: <3B9D4D8B.B5F6241A@temporaldoorway.com> Date: Mon, 10 Sep 2001 19:32:28 -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: Performance info on different data access options? References: <3b9c387a$1_2@dnews> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 24.14.197.193 X-Trace: dnews 1000164845 24.14.197.193 (10 Sep 2001 16:34:05 -0700) Lines: 19 Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!sn-xit-03!supernews.com!logbridge.uoregon.edu!news.maxwell.syr.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews