Re: Multiple Databases vs a Few

From: Uri Dimant (urid_at_iscar.co.il)
Date: 10/25/04 

Date: Mon, 25 Oct 2004 15:50:39 +0200

Brian
There are no reasons to create a database for each client. I think you are
going to build a new model of the database , only you do know a business
requrements.
Visit at www.sql-server_performance.com and you will find a really good
stuff there.

"Brian" <brian@nospam.com> wrote in message
news:%23k$J8cpuEHA.3808@TK2MSFTNGP10.phx.gbl...
> I started work a new company recently and they provide a web based tool to
> companies. The database model is in rough shape -- when a new client
comes
> on they simply create a new database for each client. Right now they have
> roughly 400+ databases split over two database servers.
>
> I am suggesting they bring that # down to a couple. I think managing 400
> connections to a variety of databases might be a performance concern. I
> would also think that in terms of Stored Procs it must be using more
> resources -- instead of optimizing 1 it has to optimize the same 1, 400
> times.
>
> Im guessing on those above --- does anyone know the postive and negatives
in
> doing this, or know of any article discussing this topic.
>
> Thanks
>
>

Relevant Pages

  • Re: Opinions needed about the best "Middleware suite" kbmMW vs. RODA
    ... kbmMW supports cross db in such way that all you need to do in your application is to set one property to switch to ... What one have to concentrate about is minimizing the amount of data moved from the app server to the client. ... C/S setup's usually have a quite active chatter going on between the client and the database, ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Access 2003 Macro Security Modification
    ... the desired way to prevent the macro security warning is to ... digitally sign your database. ... Your database fileon the client computer. ...
    (microsoft.public.access.modulesdaovba)
  • Excellent openings for an MNC Client in Blore for java,c++,.net & Testing Professionals
    ... Excellent openings for an MNC Client in Blore for java,c++,.net & ... DB2 Database Architects: 5+yrs experience ... Skills given below: ... Business analyst ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Upgrade to Server 2003
    ... That's an ADO message seen in VB6 for a variety of reasons. ... the database, but is not necessarily. ... > My client just upgraded their network from Novell to Server 2003. ...
    (microsoft.public.dotnet.general)
  • Re: Confused about proc vs. dynamic SQL vs LINQ
    ... where people create stored procs which *just* call normal CRUD ... for no reasons other than dogma. ... theoretical "change the database and the procs implementation, ... It depends on the database server, but I believe that using a cached ...
    (microsoft.public.dotnet.languages.csharp)