PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 03, 2003 10:07 PM
Subject: best way to optimize a table with many to few relationship.
> hello,
>
> I have a question about database structure and optimization.
>
> I have a shopping cart where several items can
If you have, and always will have, no more that 64 product types, you can
store the product type in a SET field. This is effectively a hybrid between
your list and boolean solutions. MySQL stores this as a bitmap with one bit
per product type and
provides the appropriate query methods. You can the
ds,
Peter
<^_^>
> -Original Message-
> From: Ken Easson [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 03, 2003 4:55 PM
> To: [EMAIL PROTECTED]
> Subject: best way to optimize a table with many to few relationship.
>
>
> hello,
>
> I have a question about data
hello,
I have a question about database structure and optimization.
I have a shopping cart where several items can fall into several of many categories,
but each item can also be several of a few product types.
my product type is limited to aprox. 5 product types. Further 99% of items will be in
hello,
I have a question about database structure and optimization.
I have a shopping cart where several items can fall into several of many categories,
but each item can also be several of a few product types.
my product type is limited to aprox. 5 product types. Further 99% of items will be in
