Im making a "back end" for an app. We have to save information about a person(id,name,value). It should be possible to insert and update a persons record, and return the 10 most valuable persons in the DB. Please note, that im using .asp (yes yes, I know ) and the DB is Access. Im posting here, because 1) im a Java dev., 2) because this might be of general interest and ummm, 3) because I don't know any asp boards.
Anyways.. A typical run is like this: you contact the server, and depending on the request the server calls eighter, the MakeRecord, UpdateRecord or PrintTop10 function.
Atm. im making a "stress test" (a simple Java program), and when run from one computer there's no problems, but when I turn on several computers, the DB crashes. When I use two computers it seems to work "ok", even though one of the computers cast an exception with HTTP response code: 500, and after a while I get a HTTP response code: 4403 I guess that's because the server crashes, since the same thing happends (code 500 -> code 403 | ok run). when e.g. three computers are beeing used. As a side note, after a "stress thread" is beeing invoked the main prog. sleeps for 150 - 1000 ms.
When im updating or inserting, im setting a lock on the DB, and therefor it makes sence, that I get an exception when several tries to get access to the DB, but it also crashes when I simply "print the 10 best persons" (that is, "SELECT TOP 10 * FROM player ORDER BY player.score DESC;").