Re: Which data engine?

From: Leslie Isaacs (leslie_at_gppayroll.net)
Date: 10/28/04

  • Next message: adai2719: "rfe" 
    Date: Fri, 29 Oct 2004 00:08:45 +0100

    Thanks for your replies.

    Now my question also involves MySQL - where does that fit in with MSDE and
    SQLServer?

    This get more complex the more I look into it!

    Is there anyone out there who can give me, in just a few lines or
    paragraphs, the significant differences between MSDE, MySQL & full-blown
    SQLServer - apart from the concurent useage issues with MSDE that are
    well-documented.

    Hope someone can help.
    Les

    "Steve Jorgensen" <nospam@nospam.nospam> wrote in message
    news:7r7gn0diqsf893ljcd3ks1dl4ajvvq76i1@4ax.com...
    > 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: adai2719: "rfe"

    Relevant Pages

    • 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?
      ... I believe the number of connections is no loger how the MSDE does its ... it's the number of concurrent requests (probably since ... >SQL-Server, with the only exception behing the maximum size of the database. ...
      (microsoft.public.access.devtoolkits)
    • 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