I need to save a lot of information which will be used as search filters. Since there are too many rows in the database, each of these filters has to be a single column of the table, so the search is fast enough. Some of them are numbers, others booleans, others strings, others dates, etc. Is it bad to add as much as 200 columns to the table? How will this affect the effectiveness of my database table? Thanks for your answers.
2007-10-08
03:41:48
·
7 answers
·
asked by
Anonymous
1