Home Forums Database Design Design Ideas and Questions Is it Better to use Multiple DB than Single DB? RE: Is it Better to use Multiple DB than Single DB?

  • July 10, 2013 at 8:52 am

    #1631262

    NeverDie (7/10/2013)

    Just to add more confidence, I've worked with more than a thousand tables in a single database and multiple of these databases running on a single server with tables having a few hundred million records in a single table. The performance was just fine.

    There are DBA's that monitor indexes etc, but this kind of architecture is very doable.

    I've also seen in my experience issues experience with multiple databases using linked servers. It may be necessary sometimes but I would suggest keeping linked servers to the area "necessity" as there are limitations with linked servers.

    Thanks a lot. This really boosted my confidence.

    Unni