Slow INSERTs to MEMORY table
Hi,
I've a performance problem with "INSERT INTO ... SELECT FROM" statement. Internal SELECT statement is fast, it based on 10M rows table and returns results in 0.3 seconds.
The problem begins when I try to insert returned results (notice, that it's only 12k records!) to another temporary tabel with MEMORY engine using "INSERT INTO ... SELECT FROM" statement. A time of whole statement is more than 5 seconds. I would add that I run on fast (16 core, 24GB RAM) dedicated server. Temporary table has no indexes, and it's empty.
So, the question is why these INSERTs to MEMORY table are so slow? Maybe sb could help me to find a solution to improve timings of INSERTS.
Subject
Views
Written By
Posted
Slow INSERTs to MEMORY table
7815
February 01, 2011 05:15AM
4068
April 24, 2011 05:52AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.