RA 3.0.39 and SQL Server

Discussion in 'Other ESET Home Products' started by erictremblay, Jan 27, 2009.

Thread Status:
Not open for further replies.
  1. erictremblay

    erictremblay Registered Member

    Joined:
    Dec 4, 2008
    Posts:
    2
    Hello,
    At what point should I consider using a SQL server instead of the provided Jet Database.

    Would 250 clients be too much to handle for the Jet Database ?
     
    erictremblay, Jan 27, 2009
    #1
  2. SmackyTheFrog

    SmackyTheFrog Registered Member

    Joined:
    Nov 5, 2007
    Posts:
    767
    Location:
    Lansing, Michigan
    I don't think 250 clients would be a problem for the Jet database. I've been running about 150 clients for 6 months and the combined database files only amount to about 4mb and db queries are running at a whopping 1.4 q/sec. The load is frankly non-existent and I wouldn't bother thinking about converting to MSSQL or Oracle unless I was experiencing performance issues or problems that one of those RDBMS could resolve.
     
    SmackyTheFrog, Jan 27, 2009
    #2
  3. dwood

    dwood Registered Member

    Joined:
    Jan 11, 2005
    Posts:
    92
    I'ved managed 500 clients on the Jet Database for the last 4+ years without any performance issues. :cool:

    Dan
     
    dwood, Jan 29, 2009
    #3
  4. Megachip

    Megachip Registered Member

    Joined:
    Dec 4, 2006
    Posts:
    243
    over 1000 clients (no problems) ... but try to migrate to mysql with 3.0
     
    Megachip, Feb 6, 2009
    #4
Thread Status:
Not open for further replies.
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...