MySQL Forums
Forum List  »  General

construct table for fast insert/select
Posted by: graceinfinity
Date: March 28, 2005 01:17PM

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 20 million entries. I will keep inserting, selecting and deleting 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
construct table for fast insert/select
March 28, 2005 01:17PM


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.