Dear List,
I need to store a set of flags in SQL, as in 20 true or false values.
The logical choice seems to be the SET type,
but does it use an index? The manual gives an examle where a set is
queried with LIKE '%flag%'. That scares me a bit,
because the table is going to contain hundredthousands of rows - and I
need to be able to filter on these flags effeciently.
I could make 20 separate rows as tinyint, but that seems like a lot of
overhead.
Anyone knows what's best in this situation?
-Sander
---------------------------------------------------------------------
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
