Article View: borland.public.cppbuilder.database.ado
Article #2078Re: Accessing highest auto number
From: Kasper Larsen
Date: Thu, 04 Dec 2003 18:44
Date: Thu, 04 Dec 2003 18:44
26 lines
2330 bytes
2330 bytes
Hi Ted Since it is a read only DB you might be able to use a solution I've used with success : I create a struct from the field definitions for each table I need. Then I simply read all rows into a stl::vector<struct>. When I need to analyse the data I use the vectors and it is a factor 5 faster then reading the Access db. I guess this indicates that the real bottleneck must be the disc access. HTH Kasper "Ted Byers" <r.ted.byers@sympatico.ca> skrev i en meddelelse news:3fcea31a$1@newsgroups.borland.com... > > I do have some performance issues to examine. On start up, I need to > process some large tables in the only read-only database I use, and that > takes about 30 seconds on my machine. However, there is one form that needs > to repeatedly access the data and analyze some of it, and this takes quite a > while. It is inherently slow because I need to retrieve the values from one > field given different combinations of the values of two other fields. > Actually, I THINK I just had an idea that may improve things a bit, but I'll > have to do some testing in the morning.
Technical Details
Message-ID:
<3fcf8077@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!irazu.switch.ch!switch.ch!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<vIB+nCAzsMz$IwBT@courtlands.demon.co.uk> <3fccec42$1@newsgroups.borland.com> <rUI$wAAUogz$IwA9@courtlands.demon.co.uk> <3fce1ab8@newsgroups.borland.com> <0x0o5DAm3lz$Iww1@courtlands.demon.co.uk> <3fcea31a$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,3afd7f6873225c1f X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-12-04 11:10:39 PST Reply-To: "Kasper Larsen" <kb_larsen@hotmail.com> From: "Kasper Larsen" <kb_larsen@hotmail.com> Newsgroups: borland.public.cppbuilder.database.ado References: <vIB+nCAzsMz$IwBT@courtlands.demon.co.uk> <3fccec42$1@newsgroups.borland.com> <rUI$wAAUogz$IwA9@courtlands.demon.co.uk> <3fce1ab8@newsgroups.borland.com> <0x0o5DAm3lz$Iww1@courtlands.demon.co.uk> <3fcea31a$1@newsgroups.borland.com> Subject: Re: Accessing highest auto number Date: Thu, 4 Dec 2003 19:44:07 +0100 Lines: 28 Organization: Seden Sytemudvikling X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 NNTP-Posting-Host: 192.38.163.42 Message-ID: <3fcf8077@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1070563447 192.38.163.42 (4 Dec 2003 10:44:07 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!irazu.switch.ch!switch.ch!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail