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
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, 2006-10
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) wit
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 pr
4 matches
Mail list logo