Re: MEMORY tables appalling insert performance

[Slawek P]

Hi,

Thanks for your comment, however by partitioning i meant that there are 10 separate tables, and the partitioning is done manually just by directing queries to appropriate table.

Eg.

table0
...
table9

$table_name = "table".($pri_key)%10;
$query = "INSERT INTO {$table_name} [..]";

So there's a problem with memory engine locking, not any other functionality in mysql.