SitePoint Sponsor |
|
User Tag List
Results 1 to 4 of 4
-
Apr 9, 2002, 11:39 #1
- 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?
-
Apr 11, 2002, 00:55 #2
- 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
-
Apr 11, 2002, 02:03 #3
- 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
-
Apr 11, 2002, 07:59 #4
- 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?
References:
http://support.microsoft.com/default...;EN-US;q174496
http://www.macromedia.com/v1/handler...40&Method=Full
Bookmarks