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 ?
     
  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.
     
  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
     
  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
     
Thread Status:
Not open for further replies.