SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Hybrid View

  1. #1
    SitePoint Zealot akohl's Avatar
    Join Date
    Jun 2001
    Location
    Israel
    Posts
    184
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    simultaneous hits on seperate db files

    I understand that ms access is quite limited in terms of the number of simulteneous hits it can process. If I create a seperate file for a table will the hits on that file interfere with hits on another file or by doing this would I be increacing the number of simulteneous users that can be serviced by my site?

  2. #2
    You want what? By when?? Milamber's Avatar
    Join Date
    Jan 2001
    Location
    California
    Posts
    342
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i cant answer this for access, but i know that in mysql (where this isn't really a problem) if it *were* you can do table locking.

    Basically, you call the table and say "lock it up for just me" and then all other requests are denied while the running script executes. After it's done, the next script can go.

    I don't know if this helps or not...
    -Jeff Minard | jrm.cc - Battlefield 2 Stats

  3. #3
    Yugo full of anvils bronze trophy hillsy's Avatar
    Join Date
    May 2001
    Location
    :noitacoL
    Posts
    1,859
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    This might help a bit.

    However I'm not sure that the limitation is just in the number of simultaneous connections the Access files can handle. It might also be a limitation of the Jet database engine.

    Interesting question. Someone should run some tests on it
    that's me!
    Now A Pom. And a Plone Nut
    Broccoli Martinez Airpark

  4. #4
    SitePoint Zealot BlitzCraig's Avatar
    Join Date
    Mar 2001
    Location
    Louisville, KY
    Posts
    114
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: simultaneous hits on seperate db files

    Originally posted by akohl
    I understand that ms access is quite limited in terms of the number of simulteneous hits it can process. If I create a seperate file for a table will the hits on that file interfere with hits on another file or by doing this would I be increacing the number of simulteneous users that can be serviced by my site?
    The magic number I read somewhere once was 255 simultaneous connections. Basically, if you're going to use MS-Access in a production environment, you need to drop your DB connections as soon as possible with either disconnected recordsets or dropping the recordset into an array.

    References:
    http://support.microsoft.com/default...;EN-US;q174496
    http://www.macromedia.com/v1/handler...40&Method=Full
    Craig H. Rettig - Bitbucket Heaven
    To understand recursion, you must first understand recursion.


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
  •