Hi,
I have tables with only 2 fields, key (char(30)) and value(blob), the value 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 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.
~Grace
---------------------------------
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
