No, you should not use stringlists like that. Unless it is just one row at a
time that is.

The most important difference between a buffered dataset and the TIB_DSQL
component is that you are not buffering up the records as you send them to
the server. Therefore you are using much less memory. To buffer inserts as
they are happening is unwise in most all cases.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Admin" <dkeith@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, March 16, 2001 12:52 PM
Subject: Re: [IBO] Big Batch...


> 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:
> >
> > Dont use TIBOQuery, its made for interactive use.
> For the fastest
> > possible inserts use TIB_DSQL. The BlobInserts
> sample application
> > that comes with IBO has an example of you to setup
> this sort of thing.
> >
> > This sounds like some sort of problem with your
> connection setup or
> > possibly even a network problem. A more specific
> error message would
> > help.
>
> David Keith
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>