ProblemHelpPlease Posted February 17, 2010 Share Posted February 17, 2010 I need to store a lot of information, about 750,000 rows of data at first but it will grow to several million. It can be categorized (each row has specific info that can be used to categorized) so I am wondering if I should create a table for each cat or to store in one table. What is the best way (in terms of reducing server load) bearing in mind that the server load includes replacing the stored data with newer content daily and in terms of searching the entire database. I understand that categorizing means I can search less data to find the records I require, but I wondered if search more tables ratther than one would be better or worse. Link to comment Share on other sites More sharing options...
justsomeguy Posted February 17, 2010 Share Posted February 17, 2010 Store it all in one table and look into using indexes as the way to speed up the search. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.