Jump to content

How Best To Store And Search A Lot Of Data


Recommended Posts

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...