Article View: borland.public.cppbuilder.database.multi-tier
Article #769Re: Very slow database
From: Martin Pennings
Date: Thu, 30 Nov 2000 00:00
Date: Thu, 30 Nov 2000 00:00
35 lines
1411 bytes
1411 bytes
Thanks, but how do I do that?
The following is the structure of my program:
String fill
fstream FileA;
FileA.open(Mainform->OpenDialog->FileName.c_str(),ios::in);
if (bestand.is_open())
{
for(;;)
{
DataModule->Table->Insert();
DataModule->Table->FieldValues["some field"]=fill.c_str();
FileA >> fill.c_str()
// there are 18 fields that are loaded the same way
DataModule->Table->Post();
if(bestand.eof()) break;
}
}
FileA.close();
How can I put all this in one transaction?
"Mark Vejvoda" <mvejvoda@soft-haus.com> schreef in bericht
news:903ha9$jcd8@bornews.inprise.com...
> Try doing it all in once transaction: StartTransaction... import the file,
> then Commit.
Technical Details
Message-ID:
<3a260a0e_2@dnews>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<3a240af5_2@dnews> <903ha9$jcd8@bornews.inprise.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fcd2b,d6f3644109147f18 X-Google-Attributes: gidfcd2b,public From: "Martin Pennings" <mpennings@pentis.nl> Subject: Re: Very slow database Date: 2000/11/30 Message-ID: <3a260a0e_2@dnews> X-Deja-AN: 699430805 References: <3a240af5_2@dnews> <903ha9$jcd8@bornews.inprise.com> X-Trace: 30 Nov 2000 00:04:30 -0800, 193.79.185.10 X-MSMail-Priority: Normal X-Priority: 3 Newsgroups: borland.public.cppbuilder.database.multi-tier X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600