Article View: borland.public.cppbuilder.database.ado
Article #2941Re: Creating Access DB in Builder
From: In�s Fern�ndez
Date: Mon, 10 Feb 2003 17:20
Date: Mon, 10 Feb 2003 17:20
21 lines
1949 bytes
1949 bytes
> I found that creating a table via SQL results in the table data itself taking > up about twice as much space as it's supposed to, and taking twice as long to > search through. I don't know why this is, but when the same exact table > definition is created via ADOX, the table size and speed is normal. Needless > to say, this is after compacting that the size comparison is made, since > creating and populating an Access database will give you a file almost twice > as large as it is after compacting. Just a silly newbies question: I have been using BDE controls, but just some days ago I started to use ADO controls. I am creating a table using the SQL sentence "CREATE TABLE..." as the command text of a TADOCommand. Is that creating it via SQL or via ADOX? (sorry, I don't understand what does mean "via ADOX") TIA: Ines Fernandez
Technical Details
Message-ID:
<3e47df45$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mailReferences:
<3e3ef595$1@newsgroups.borland.com> <gunaalqrneguyvaxarg.h9s1xy0.pminews@207.105.83.65>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,cf0428e56f70fa7d X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-02-10 09:24:08 PST From: "In�s Fern�ndez" <ifernandezmed@terra.es> Newsgroups: borland.public.cppbuilder.database.ado References: <3e3ef595$1@newsgroups.borland.com> <gunaalqrneguyvaxarg.h9s1xy0.pminews@207.105.83.65> Subject: Re: Creating Access DB in Builder Date: Mon, 10 Feb 2003 18:20:07 +0100 Lines: 23 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 80.59.94.142 Message-ID: <3e47df45$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1044897605 80.59.94.142 (10 Feb 2003 09:20:05 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail