Subject | Re: Big Batch... |
---|---|
Author | Aage Johansen |
Post date | 2001-03-20T19:19:53Z |
No help, sorry, just questions:
1. If the IB server runs on another machine, how busy is it when you run
the program (CPU/disk-activity)?
2. If you comment out the database stuff, how is the rest of the code
performing (any bottlenecks outside of IB/IBO)?
Regards,
Aage J.
Dave wrote:
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.
------------------------------------
1. If the IB server runs on another machine, how busy is it when you run
the program (CPU/disk-activity)?
2. If you comment out the database stuff, how is the rest of the code
performing (any bottlenecks outside of IB/IBO)?
Regards,
Aage J.
Dave wrote:
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.
------------------------------------