SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Zealot eStudio's Avatar
    Join Date
    Dec 2001
    Location
    NE Texas
    Posts
    153
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    At what point do I move Access to SQL?

    I need some feedback on when it is recommended to move a db from Access to SQL? Any benchmark testing resources you may be able to post would be helpful too.

    Is it based on the # users within a time frame, db size, etc.???

    Any info appreciated.


    TIA,
    Donna

  2. #2
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    When you move out of development and into production. Access was never meant to be a production level server. Heck I would develop in SQL Server if I could and just use Access's pretty front-end to manipulate the data through ODBC using nicely formatted forms and reports.
    Wayne Luke
    ------------


  3. #3
    \m/ R.I.P. Dimebag! \m/ JimBolla's Avatar
    Join Date
    Dec 2001
    Location
    erie, pa
    Posts
    1,130
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    when? how about when you can afford it.

  4. #4
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by crowdozer
    when? how about when you can afford it.
    Seems resonable to me, thats the only reason why I use access

  5. #5
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,014
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    donna, is this for a client-server network? intranet? or the database for a web site?

    i've heard anecdotal evidence that the "uh oh" point is ten simultaneous users

    let's say your web site gets 10,000 visitors a day
    (i wish)

    that's 417/hour, or 7/min, or 1 user every 9 seconds

    if the database call is less than 9 seconds (quite reasonable, as most access calls are a second or less), then you'll be fine

    now, even if you had a hundred site visitors at a time, they aren't all going to hit the enter key at the same time -- they'll be reading a page, then navigating, then reading some more...

    so you could have umpteen simultaneous site visitors and still not get ten simultaneous access users


    helps?
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  6. #6
    SitePoint Zealot eStudio's Avatar
    Join Date
    Dec 2001
    Location
    NE Texas
    Posts
    153
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks to everyone...just trying to get some insight. This is a web site and I just launched a couple weeks ago and have redirected their old web site not knowing how much traffic to expect. The site is getting 500-700 sessions per day - 13,000+ page views per week, so I am thinking it may be time to move to SQL.

    We have only added 2 lines of product out of several hundred so had not expected much use of the site this quickly. A good problem to have, but still a problem.

    Anyway, thanks to all!



    Donna


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •