MySQL Forums
Forum List  »  General

CREATE TABLE for fast insert/retrieval
Posted by: graceinfinity
Date: April 05, 2005 06:41PM

Hi,

I have tables with only 2 fields, key (char(30)) and value(blob), the blob in average is about 2K.

The table is going to store more than 100 million entries. I will keep inserting to and selecting from the table. I wonder what will the best way be to construct the table, i.e., how should I do 'create table ....'.

I know I need to index the key, but shall I also index the value? shall I set up key or primary key for the key? What is the way to construct table to achieve the best performance based on the fact that it's a SIMPLE (only 2 fileds) but GIANT table?

Thanks very much.

Options: ReplyQuote


Subject
Written By
Posted
CREATE TABLE for fast insert/retrieval
April 05, 2005 06:41PM


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.