Hi,
I currently have a table with 2 columns, product_id and feature. Each
product_id can have multiple features.
My two columns are:
product_id is type char(13)
feature is type varchar(128)
In order to make sure I don't have the same feature listed twice for a
particular product, I have set the PRIMARY key on product_id and feature.
I have lots of products and lots of features. Is design bloating my
available key_buffer memory with too much data?
Is there a better way to index this data?
Thanks,
Grant
---------------------------------
Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays,
whatever.
