Hi
I have a web registration form which has a series of checkboxes on it (less than 64).
I have read the check article on phpbuilder and was wondering what is the best solution to store the checkbox data. Ideally, I would like to have something less complicated than
having serveral tables devoted to this.
So my question is this: performance-wise, how does the MySQL SET type compared to a bigINT bitflag implementation? Can indexes be used efficiently on either one of them? Or is there a better solution?
Thanks!
I have a web registration form which has a series of checkboxes on it (less than 64).
I have read the check article on phpbuilder and was wondering what is the best solution to store the checkbox data. Ideally, I would like to have something less complicated than
having serveral tables devoted to this.
So my question is this: performance-wise, how does the MySQL SET type compared to a bigINT bitflag implementation? Can indexes be used efficiently on either one of them? Or is there a better solution?
Thanks!