If you can batch the inserts into groups (of say 10 to 100) it might
help performance - i.e:
Instead of
INSERT INTO table VALUES(...);
INSERT INTO table VALUES(...);
...
INSERT INTO table VALUES(...);
do
INSERT INTO table VALUES(...),(...),...,(...);
This reduces the actual number of INSERT calls, which can be quite a win.
Regards
Mark
On 28/01/12 07:30, Jayashankar K B wrote:
> Hi Heikki Linnakangas: We are using series of Insert statements to insert the records into database.
> Sending data in binary is not an option as the module that writes into DB has been finalized.
> We do not have control over that.
>
>