• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DB crashes when it's used simultaneous

Svend Rost
Ranch Hand
Posts: 904
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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;").

Pointers, ect. ?

Thanks in advance,

/Svend Rost
[ May 10, 2005: Message edited by: Svend Rost ]
Paul Sturrock
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm afraid to say that the simple answer is change Databases. Access is not a very good DB, and suffers "issues" with concurrent access.

(BTW - you might try MSDN for your Microsoft questions. Not that people here will probably mind answering them, just you are far more likely to get a better response. )
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic