We use mysql 4.1.13a with myISAM storage engine.
I have googled a lot without success, so I hope somebody will answer
Also, I’m not english fluent, hope it is not too boring to read me )
We have a lot of “flag” in our database.
By flag I mean attribute with “Yes” or “No” (like “this image is in color” or “this image is panoramic”).
I’m looking for the best performance to search on that kind of field.
I see many manner to do it:
- integer (with 0 or 1)
- string (Y or N)
- enum (Y/N or 1/0)
But also I can use NULL way, I mean
- integer (1 and NULL)
- string (Y and NULL)
Whats is the speediest way to perform that kind of search ?
Thanks for your time