Re: MEMORY tables appalling insert performance
Posted by:
Slawek P
Date: October 26, 2009 03:57PM
I'm wondering why partitioning doesn't work. Is that because there is one "memory pool" that gets locked for each write/update operation (so when value is inserted all the memory tables are locked?).
Maybe there is some concurrency problem? Did maybe someone tried a FIFO buffer in form of a NON-BLOCKING proxy that takes INSERT/UPDATE/DELETE ops and executes them one-by-one?
Subject
Views
Written By
Posted
12522
October 26, 2009 11:46AM
Re: MEMORY tables appalling insert performance
6227
October 26, 2009 03:57PM
5589
December 31, 2009 01:30AM
5388
December 31, 2009 10:20AM
5859
December 31, 2009 01:43AM
5844
December 31, 2009 10:18AM
5358
December 31, 2009 08:54PM
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.