MySQL Forums
Forum List  »  Memory Storage Engine

Slow INSERTs to MEMORY table
Posted by: Rafal Plewa
Date: February 01, 2011 05:15AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Slow INSERTs to MEMORY table
7007
February 01, 2011 05:15AM
3447
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.