New database or more tables in single database?

  • Resolved srujanika

    (@srujanika)


    6 years, 11 months ago

    Hello,
    We have some interactive features in our WordPress site odiabibhaba.in which come with their own data. Presently we are keeping these data in tables in the main (only) MySQL database along with all WordPress data. The tables are large – more than 10 mb each.
    Is this aceeptable practice? Or should we keep these data in separate MySQL databases and use the appropriate steps in our php program to retrieve the data as needed? Which would be better?
    Our hosting package allows us to add several databases, so that is not a problem.
    Would appreciate any help and guidance in the matter.
    Thanks,
    Nikhil

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator James Huff

    (@macmanx)

    There isn’t much of a performance impact at all, if it were me I’d keep it all under the same database since it’s part of the same site.

    Thread Starter srujanika

    (@srujanika)

    Thanks a lot – it certainly is reassuring to hear this. The website is our maiden venture and we know very little technically.
    Regards,
    Nikhil

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘New database or more tables in single database?’ is closed to new replies.