943,718 Members | Top Members by Rank

Web Development > Databases > MySQL > 1 Large Database or 400 smaller
Ad:
  • MySQL Discussion Thread
  • Unsolved
  • Views: 2037
  • MySQL RSS
Permalink
Jun 4th, 2007
0

1 Large Database or 400 smaller

Expand Post »
I need some advice from the pro's

I am building an application that has data from several places. The structure is all the same but the data is specific to a user.
1 such a feed can consist of 50,000 rows but on average it's more between 500-2000 rows. In total there will be about a 400 different tables.

I am in doubt if I should merge all data into 1 big table. The number of rows will go beyond 2 million I suspect.

My main "problem" is I want to be able to search and select
in the description and title column and that should be done over all tables if I keep it the original way.

What is the best way to tackle this. Something to note is that the search and select is at the backend where no actual visitor will be bothered as they only see the end result.
Similar Threads
Reputation Points: 29
Solved Threads: 0
Newbie Poster
edynas is offline Offline
3 posts
since Jun 2007
Permalink
Jun 8th, 2007
0

Re: 1 Large Database or 400 smaller

I've never used MySQL, but since your structure is the same in all cases, it makes ssnse to put everything into one big database with a key to indicate which user each record belongs to. That will probably save you a lot of trouble in the long run. For instance, if you need to change the structure later, it will be a lot easier to change in once instead of 400 times. The only question is if MySQL can handle that number of records without a problem.
Reputation Points: 12
Solved Threads: 1
Light Poster
Terry Robinson is offline Offline
27 posts
since Apr 2007
Permalink
Jun 8th, 2007
0

Re: 1 Large Database or 400 smaller

I do think i will move forward with that idea too. Been thinking about it and asked around a bit and altho I didn't got much response what I heared was it should not be a problem to put it all in 1 big db.

I do want to make sure tho that mysql is capable of handling 2 million rows and what alternatives are.
Reputation Points: 29
Solved Threads: 0
Newbie Poster
edynas is offline Offline
3 posts
since Jun 2007
Permalink
Jun 12th, 2007
1

Re: 1 Large Database or 400 smaller

I didn't see this thread sooner and it may now be too late, but 1 database is the way to go; easier to manage, easier to optimise, easier to backup, faster, requires less disk space.. 1 database is better in every way.

Don't be worried about the number of rows in a database; they are designed to cope with large volumes of data.
pty
Reputation Points: 64
Solved Threads: 39
Posting Pro
pty is offline Offline
530 posts
since Oct 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: Scope of Datawarehouse
Next Thread in MySQL Forum Timeline: Nav buttons for MySql and PHP





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC