Subject | Parameterized inserts? |
---|---|
Author | Joe Martinez |
Post date | 2002-11-07T06:27:46Z |
I've read in numerous posts that when you're inserting a lot of records
into a table, it's best to:
1) use IB_DSQL
2) use a prepared parameterized insert
3) commit about every 15,000 records
First, I'm not really sure how to do a parameterized insert. I can't find
any documentation that tells me exactly what I need to do to make it
happen. I see properties for Params, ParamChar, ParamCheck, ParamCount,
ParamValues, etc., but I don't have a good idea of how they all work
together, or what methods I need to call. Can someone lay it out for me,
or point me to some documentation on it? I have the IBO Help, and Getting
Started Guide, but can't find this info.
Second, I'm attaching the IB_DSQL object to a TIBODatabase. It has
AutoCommit set to True. If I leave it at True, will it automatically
commit after each insert? Do I need to set it to False to manually commit
at 15,000 records?
Thanks,
Joe
into a table, it's best to:
1) use IB_DSQL
2) use a prepared parameterized insert
3) commit about every 15,000 records
First, I'm not really sure how to do a parameterized insert. I can't find
any documentation that tells me exactly what I need to do to make it
happen. I see properties for Params, ParamChar, ParamCheck, ParamCount,
ParamValues, etc., but I don't have a good idea of how they all work
together, or what methods I need to call. Can someone lay it out for me,
or point me to some documentation on it? I have the IBO Help, and Getting
Started Guide, but can't find this info.
Second, I'm attaching the IB_DSQL object to a TIBODatabase. It has
AutoCommit set to True. If I leave it at True, will it automatically
commit after each insert? Do I need to set it to False to manually commit
at 15,000 records?
Thanks,
Joe