Lloyd [EMAIL PROTECTED] wrote:
Hi,
When this 3M inserts are performed, it takes 130 more seconds compared
to the actual application running time. The actual application run time
is 20 seconds but when this 3M inserts are performed it takes 150
seconds.
Is there any way to reduce the time
Hi,
How much time it may take to insert or ignore into query for 30
lakhs times. It adds more than 130 sec overhead compared to the 20 sec
of execution time. All these are done inside a single transaction. And
these insertions are made on three tables (on each table 10 lakhs) with
a combined
Lloyd wrote:
Hi,
How much time it may take to insert or ignore into query for 30
lakhs times. It adds more than 130 sec overhead compared to the 20 sec
of execution time. All these are done inside a single transaction. And
these insertions are made on three tables (on each table 10 lakhs) with
Hi,
When this 3M inserts are performed, it takes 130 more seconds compared
to the actual application running time. The actual application run time
is 20 seconds but when this 3M inserts are performed it takes 150
seconds.
Is there any way to reduce the time ?
Thnaks,
Lloyd.
On Mon,