I would too... The set method is very quick as it only performs an assembler logical AND to find which types are there and returns them like "typeA,typeB,etc". I can't find something faster than that.
The drawback would be scalability as in order to add types one must modify the structure of the table (which if does not happen too often is okay).
Altering a table with 1M rows takes about 30 seconds. Adding indices though takes quite some time. (tried many times with tables 3M rows containing GPS data).
Quote:
Originally posted by Intrigue
personally i'd use the set method.
|