Re: Huge heap vs performance
Posted by:
Jeff C
Date: November 25, 2007 11:23PM
There currently is a bug with memory tables, where periodically deletes on btree indexes take longer than expected.... HOWEVER, I currently have my summary tables built and loaded all into memory tables (using btree) and I can handle a lot more than I could with myisam.
Some of my queries are complex and do full table scans... where the table is memory it blazes. You should really try it out.
init-file -- lets you run sql at startup... throw some sql to build your memory tables at startup.
I mentioned the bug because you may see a period where deletes aren't 0.01 seconds.
Where the memory tables have been outgrown, InnoDB fits well.
Subject
Views
Written By
Posted
11536
October 05, 2007 02:42PM
Re: Huge heap vs performance
6915
November 25, 2007 11:23PM
5529
January 28, 2009 07:43AM
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.