Which data engine?

From: Leslie Isaacs (leslie.isaacs_at_gp-n85011.nhs.uk)
Date: 10/21/04


Date: Thu, 21 Oct 2004 09:07:11 +0100

Hello All

Apologies for the cross-posting - but in case I have omitted the most
appropriate group I would be very grateful if someone could direct me to
whichever it might be.

I am contemplating the development of a General Management application for
use in doctors' surgeries. The application will be wide-ranging, including
modules for payroll, accounts, rotas, significant event reporting and
analysis, personnel, plus others.

I need to decide between using MSDE or the full SQL Server engine. For
obvious cost reasons MSDE would be preferable, but despite having read all I
can find on the web I am still unsure about the concurrent user limitations
of MSDE. Does anyone out there have experience of having deployed an
application using MSDE into an environment in which there are regularly,
say, 10 concurrent users? Or 20? Does MSDE allow for 'queuing' of loggins,
after a given threshold?

I would be very grateful to hear from anyone with experience of these
issues, or for any pointers to where I might find people with this
experience.

Many thanks.
Leslie Isaacs



Relevant Pages

  • osql doesnt work
    ... I'd be grateful if you can help me with the following. ... connect to an instance of MSDE called BALTD. ... [-O use Old ISQL behavior disables the following] ...
    (comp.databases.ms-sqlserver)
  • Which data engine?
    ... whichever it might be. ... I need to decide between using MSDE or the full SQL Server engine. ... can find on the web I am still unsure about the concurrent user limitations ... I would be very grateful to hear from anyone with experience of these ...
    (microsoft.public.access.devtoolkits)
  • Re: Help on database choice?
    ... there is only 1 concurrent user but that user has ... "Ian" wrote in message ... > anyone can confirm speed comparisions using MSDE ... > rather than mySQL. ...
    (microsoft.public.sqlserver.msde)
  • Merge Replication and MSDE 2000
    ... Hello..I am going to implement Merge Replication with MSDE 2000. ... please let me know how many users MSDE 2000 can burden the workload. ... will degrade the preformance if more than 5 concurrent user will start ... What is the procedure in order to implement merge Replication on MSDE ...
    (microsoft.public.sqlserver.replication)

Loading