Hello,
I use a lot of SET-alike fields in my tables. The fields are used to store
properties and such; every bit stands for a specific value. The fields are
queries like 'where property_field & 1<<4' or 'where property_field & 1025'
if you look for more than one property.
Just your average SET behavoir and very convenient to use.
The only problem is these queries are slow. You need to do a tablescan to
find the matching records. Making a seperate table where you store an entry per
property is another option but even slower (makes a big difference after
even a few tens of thousend of rows).
Any hint / tips / ideas how to index a set-like field?
Thanks,
Harmen
--
The Moon is Waning Gibbous (93% of Full)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
