MySQL Forums
Forum List  »  Performance

Memory mirror for read-only tables?
Posted by: Thomas Courl
Date: August 11, 2009 05:43PM

Hi,

I'm facing the following challenge: I have a couple of fairly large tables (~15 million rows that each contain 3 columns: 1 BIGINT, 1 INT and 1 FLOAT) and I need to significantly improve the read performance (Select commands need to improve by factor 20 to 30).

As those tables are read-only (i.e. they contain "expert" values that will never be changed), my best guess to improve the performance is to create a stored routine that will automatically mirror the concerned tables in MEMORY tables (not sure yet how to do this).

Would this approach make sense? Any better ideas?

Also: while the BIGINT column is the primary key, I'm using the INT field as condition in my Select commands (each returning ~5000 rows). Hence I created a BTREE Index for this column. How should I decide between BTREE and HASH or other options?

Many thanks!
Thomas

Options: ReplyQuote


Subject
Views
Written By
Posted
Memory mirror for read-only tables?
4727
August 11, 2009 05:43PM


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.