🚀 go-pugleaf

First of all I'm a Delphi programmer and my comments/code is from memory.
What you want is something like

query1->Prepare;

for (i=0;i<9800000;i++)
{
query1->ParamByName("f1")->AsString = f1[i];
........................................................................
query1->ParamByName("fn")->AsString = fn[i];
query1->Execute;
}

query1->UnPrepare;


in your ado query component you'll have some sql like ...

INSERT INTO MYTABLE (f1, ... fn) VALUES(:f1, ... fn)

1) The point is that SQL in the query only refers to the columns you want to
set values for (i.e. f1, f2 ...) and this update is performed at the
database; you are not literally requiring the whole table to be brought down
first to be changed
2) I think preparing the query may not be valid for ADO components (you can
check if this is supported) but if it is then it could improve performance.
3) If you are using ADO Express I think its been found that performance can
be slow.  The alternative is to use to import the ADO type library, ADOInt,
and essentially use ADO directly in code (no visual components here)
4) If you insist on using the table component posting the records at the end
only may help as appending records implicitly posts the last record (i.e you
moving off the last inserted record results in it being posted
automatically) i.e.

for (i=0;i<9800000;i++)
{
Table1->Append();
Table1->FieldByName("f1")->AsString = f1[i];
........................................................................
Table1->FieldByName("fn")->AsString = fn[i];
}
Table1->Post();


"Avex" <I@dont.like.spammar> wrote in message news:3c1ef4d8_1@dnews...
> I dont understand, would you plz give me an example ?
>
> "Ray" <SpamBlows@everywhere.com> wrote
> :3C1EB39E.D8A8EE26@everywhere.com...
> > instead of using a table use a query so that the whole table
> > doesnt have to be loaded
> > and maybe post all the records at the end..not each individually
> >
> >
> >
>