Is all I can say here is that the way inserts are done in the BlobInserts
sample applications is the fastest way to do them from a client using
InterBase. Using external tables is also fast but you can't do blobs with
them and you have to be local to the server.

If there are other issues slowing things down try looking at disabling your
indexes and the setting of forced writes for the database. Either of these
factors can load the performance down considerably.

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

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


> Jason -
>
> All that I can tell you from the minimal depth that I understand this
> from is that the DSQL component didn't get the job done any faster than
> a TIBOQuery, TIBOTable etc. I'm trying to find a strategy to make this
> fast. 14,300+ is a big number, but the actual quantity of data is small
> - one column of 9 characters in a CHAR column in a dialect 1 database.
>
> There ought to be a way on the database side to make this extremely
> fast. However, the data originates on the internet, where I download
> csv's from. Then my delphi code parses out the symbol data into
> TStringLists, and from there it goes into the database.
>
> I noticed that when I did this with a Paradox table it was many times
> faster. Perhaps that's the best approach...
>
> Thanks again.
>
> David Keith
>
> Jason Wharton wrote:
> >
> > 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/
> > >
> > >
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
>
> --
> Please review the attached resume and skills narrative in consideration
> for the position of , and contact me at your earliest convenience.
>
> Thank you.
>
> 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/
>
>