Re: Which data engine?

From: Steve Jorgensen (nospam_at_nospam.nospam)
Date: 10/21/04

  • Next message: Brown: "Package and Deployment" 
    Date: Thu, 21 Oct 2004 20:43:48 GMT

    I believe the number of connections is no loger how the MSDE does its
    throttling. Instead, it's the number of concurrent requests (probably since
    zombie connections are such a ubiquitous issue). This means that, once 5
    concurrent requests are already being processed, any additional requests wait
    in a Queue until one of the original 5 is completed.

    In any case, if you hover around the 10 user mark, and the users are doing
    mostly data entry and single-record lookups, with a few reports and analyses
    here and there, you're doing fine (so long as the 2GB database size limit is
    also adequate). Much beyond that, and users will start to complain, and you
    may experience timeout errors.

    On Thu, 21 Oct 2004 16:11:27 -0400, "Sylvain Lafontaine" <sylvain aei ca (fill
    the blanks, no spam please)> wrote:

    >MSDE is tuned for five concurrent connections, but a connection is not the
    >same thing as a login. You can have tens of logins and still have a
    >handfull of connections.
    >
    >Also, you don't have to decide beetween MSDE or SQL-Server. Excerpt for
    >very fews and specialised functions, MSDE offer the same support as
    >SQL-Server, with the only exception behing the maximum size of the database.
    >However, if you want to switch later from MSDE to SQL-Server, it's a very
    >easy step and involve no change in your coding.
    >
    >My suggestion for you would be to buy the Developer Edition of SQL-Server,
    >at about 50$US, and start learning the stuff.
    >
    >S. L.
    >
    >"Leslie Isaacs" <leslie.isaacs@gp-n85011.nhs.uk> wrote in message
    >news:%23QHV5T0tEHA.3152@TK2MSFTNGP14.phx.gbl...
    >> 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
    >>
    >>
    >

  • Next message: Brown: "Package and Deployment"

    Relevant Pages

    • Re: SQL-Server Lizenzen und ADO DB-Connections
      ... > der eigentlichen EXE per Shell-Befehl aufgerufen wird. ... Pro eingebautem Prozessor im Rechner muss eine Lizenz für den SQL-Server ... Die MSDE bedarf als solches keinerlei Lizenzen, ... Connections auf 8 beschränkt wurde. ...
      (microsoft.public.de.vb.datenbank)
    • Re: Can you have 50 simultaneous web users with a MSDE, ASP.NET/ADO.NET backend...?
      ... I understood his post as requesting confirmation for his impression ... that replacing his Access database with an MSDE database would ... increase his his website's capacity to serve customers, since MSDE ... doesn't choke on 50 simultaneous connections while Access might. ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Prevent Viewing on worksheet
      ... decrease performance after a certain number of connections.. ... get one copy of XP developer and you can distribute MSDE and the Access ... oracle and db2 are ridiculously priced. ...
      (microsoft.public.excel)
    • Re: MSDE and Windows 98 connection problems
      ... which runs at several platforms with MSDE. ... > When I run my application on Windows 98 and MSDE then MSDE suddently stops ... > that it stops when it reach about 30 connections, ... > installation to version 2.7.1, which means that MDAC doesn't work at all ...
      (microsoft.public.sqlserver.programming)
    • Re: Which data engine?
      ... paragraphs, the significant differences between MSDE, MySQL & full-blown ... it's the number of concurrent requests (probably ... > zombie connections are such a ubiquitous issue). ...
      (microsoft.public.access.devtoolkits)
    Loading