Re: IMDB data processing
Posted by:
Rick James
Date: August 24, 2012 08:44AM
You are using ENGINE=MEMORY?
Can you shrink the datatypes? VARCHAR(50), especially if it is utf8, is a rather long GUID; it will take 152 bytes of memory in the MEMORY engine.
Please provide SHOW CREATE TABLE for each table. I need to know whether you are using HASH or BTree indexes, and what field(s) are indexed.
Please provide the actual SELECT statement; handwaving is not sufficient.
Better yet, do EXPLAIN SELECT...
You may even find that InnoDB, with suitable indexes, will run faster than MEMORY!
Subject
Views
Written By
Posted
7375
August 21, 2012 07:36AM
Re: IMDB data processing
2658
August 24, 2012 08:44AM
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.