Richard Ollier wrote:
Hello, For a project I have a table containing products and flags. The columns of this table are of 2 kinds : - Not null data (id, column1, column2) - Flags (100 different flags set to 1 or 0) Over the time the number of flag will increase from 100 to 200 or more.
Having 200 flags as 200 fields... Writing queries on that is going to be painful.
I would probably look at bitwise operations, although 200 bits is quite a bit larger than a bigint. Maybe an array of ints would work...
I don't suppose you expect 2^200 different combinations, maybe some of the flags can be grouped together?
-- Alban Hertroys alban@xxxxxxxxxxxxxxxxx magproductions b.v. T: ++31(0)534346874 F: ++31(0)534346876 M: I: www.magproductions.nl A: Postbus 416 7500 AK Enschede // Integrate Your World //
