The Little Guy Posted December 20, 2009 Share Posted December 20, 2009 I am not sure what the best approach to this would be... A. Have multiple tables all with the same columns, but each table will be for a specific category, such as: health, science, programming, general, etc.. OR B. Have one table with everything in there, and a column for the category id, which will be a foreign key to a category table. I don't know what would be the fastest way, because I am planning to have millions of values in the table(s), and I am going to be using a Full Text Search on the question column. So what way would be for optimum speed? Quote Link to comment Share on other sites More sharing options...
haku Posted December 21, 2009 Share Posted December 21, 2009 B. Add an index to the question column. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.