Subject | Re: insert optimization |
---|---|
Author | Svein Erling |
Post date | 2003-05-22T21:05:41Z |
Hi Erik,
what do you mean by "quite slow". And how do you insert? We cannot
tell you whether it is possible to improve speed without knowing
anything about what you do at present. I know that it is not
difficult to write a program that inserts a couple of thousand
records per second if the insert is simple and the program and data
to insert is on the same server as the database.
But:
-I do not know how you insert
-I do not know whether you want to commit for every insert or not
-I do not know whether your insert statement will vary from one
insert to another (insert into same or different table/field)
Hence, I cannot answer your original question.
Set
--- In ib-support@yahoogroups.com, "Erik S. LaBianca" <erik@t...>
wrote:
what do you mean by "quite slow". And how do you insert? We cannot
tell you whether it is possible to improve speed without knowing
anything about what you do at present. I know that it is not
difficult to write a program that inserts a couple of thousand
records per second if the insert is simple and the program and data
to insert is on the same server as the database.
But:
-I do not know how you insert
-I do not know whether you want to commit for every insert or not
-I do not know whether your insert statement will vary from one
insert to another (insert into same or different table/field)
Hence, I cannot answer your original question.
Set
--- In ib-support@yahoogroups.com, "Erik S. LaBianca" <erik@t...>
wrote:
> Hi all,
>
> I wondering if any of you have had any luck speeding up inserts to
> interbase? I've found that using both DBD::InterBase and IBX under
> delphi insert operations are quite slow. I've tried playing with my
> transaction component settings in delphi to no avail.
>
> Is using an external table the only way to get data in faster?