Hi guys, I have a client who has asked me a question and I'm not really to sure how to handle it.

So I have a pretty heavy drupal 5.x site set up with 1600 nodes, a lot of users and custom themes.
I just finished setting up a support part for the site where the client is going to be adding an invoice if you want to call it for all the products he sells. He has roughly 5000 buyers and each buyer buys around 2-5 products minimal from him a year.

So lets say I'll be adding roughly 25,000 extra nodes a year to the site for the support site.

His question was "Shouldn't we be creating a new database so our support side doesn't slow down our site."
Our current database is 35,693 KB.

Is creating a new database going to help? Is it worth doing? If so how would I go about doing this task?

Thanks for your time / help,
Justin

Comments

mm167’s picture

a 35M database is NOT big.
5000 buyers x 5 product / 1 yr = 5000 x 5 / 250 = 100 / day ....NOT a heavy loading

unless u are using very low price share host (say $5 a month), I dont think u need to worry about it.

hinchcliffe’s picture

We have a dedicated server, but after lets say 5 - 10 years will the database get bogged down?

Thanks for the input.