Member Avatar for justted

hello,

I am just about to re-organise my database which is done using MySQL.

My current database is quite large and i have concerns that if I gain alot of members then the database may not be able to cope and the performance of the website may be affected.

My question is which option is better ....

To continue and use the ONE database to contain all the information

OR

To set up multiple databases such as one for member details and profiles .... one for keeping the data on games and stats, one for account transactions, etc!

Would setting up multiple databases and splitting the current content/tables in the one I have speed up queries and also would it be better for security?

Any help would be appreciated

Justin

  • 1 Contributor
  • 1 Reply
  • 69 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by justted
Member Avatar for justted

oh and just to mention my current database has approx 200+ tables and some of these contain over 14,000 rows of data.

I expect the other tables to increase in size which would obvioulsy be a large amount of data flying around. :D

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.