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? Link to comment https://forums.phpfreaks.com/topic/185820-one-or-more-tables/ 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. Link to comment https://forums.phpfreaks.com/topic/185820-one-or-more-tables/#findComment-981252 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.