🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #769

Re: Very slow database

#769
From: Martin Pennings
Date: Thu, 30 Nov 2000 00:00
35 lines
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-mail
References: <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