Subject | Re: [IBO] Big Batch... |
---|---|
Author | Admin |
Post date | 2001-03-16T19:52:22Z |
Geoff -
Thanks for the reply. I'm trying it now with the dsql
component.
However, all I've done is set the SQL property to use the
previoulsy
mentioned INSERT statement. It's executing one row at a time as
I write
this, no more quickly than the TIBOQuery did. Is there a better
approach
to doing this? Or should I continue to pursue doing this in
multiple
threads?
Incidentally, I'm parsing the data into TStringLists prior to
inserting
into the database. Is there any in memory structure that I
could use to
just jam the stringlist's strings into the table all at once?
You know,
one big simultaneous transaction? Just a thought.
TIA
Dave
Geoff Worboys wrote:
[Non-text portions of this message have been removed]
Thanks for the reply. I'm trying it now with the dsql
component.
However, all I've done is set the SQL property to use the
previoulsy
mentioned INSERT statement. It's executing one row at a time as
I write
this, no more quickly than the TIBOQuery did. Is there a better
approach
to doing this? Or should I continue to pursue doing this in
multiple
threads?
Incidentally, I'm parsing the data into TStringLists prior to
inserting
into the database. Is there any in memory structure that I
could use to
just jam the stringlist's strings into the table all at once?
You know,
one big simultaneous transaction? Just a thought.
TIA
Dave
Geoff Worboys wrote:
>For the fastest
> Dont use TIBOQuery, its made for interactive use.
> possible inserts use TIB_DSQL. The BlobInsertssample application
> that comes with IBO has an example of you to setupthis sort of thing.
>connection setup or
> This sounds like some sort of problem with your
> possibly even a network problem. A more specificerror message would
> help.David Keith
[Non-text portions of this message have been removed]