Morgan
SCJP (1.4), SCJD (1.4), SCWCD (1.3), SCBCD (1.3)
Originally posted by morgan bath:
"Your server must be capable of handling multiple concurrent requests, and as part of this capability, must provide locking functionality as specified ...."
What do they mean by handle? Does it mean it must be able to process requests in parallel, or does it mean I could have a single instance DB and sync the methods and so deal with the request sequentially? It depends totally on what they mean by HANDLE. Any takes?
Morgan
SCJP (1.4), SCJD (1.4), SCWCD (1.3), SCBCD (1.3)
Regards, George
SCJP, SCJD, SCWCD, SCBCD
Morgan
SCJP (1.4), SCJD (1.4), SCWCD (1.3), SCBCD (1.3)
Regards, George
SCJP, SCJD, SCWCD, SCBCD
Morgan
SCJP (1.4), SCJD (1.4), SCWCD (1.3), SCBCD (1.3)
Originally posted by morgan bath:
But most people seem to have a list of locked records stored somewhere, do I need to do that in a single instance DB with synced methods? It seems to me that having a lock on the entire db cache will work.
It seems less efficient for responce time, but unless a few hundred clients submit requests at a single time I doubt it would be noticed.
Regards, George
SCJP, SCJD, SCWCD, SCBCD
Originally posted by George Marinkovich:
Hi Morgan,
but aren't you effectively doing database locking rather than record locking. And if so, aren't you sacrificing a lot of concurrency in the bargain? So I guess I'm saying it might work but you might not be as happy with the performance as you might be if you implemented record locking.
George
Morgan
SCJP (1.4), SCJD (1.4), SCWCD (1.3), SCBCD (1.3)
Regards, George
SCJP, SCJD, SCWCD, SCBCD
Morgan
SCJP (1.4), SCJD (1.4), SCWCD (1.3), SCBCD (1.3)
Originally posted by morgan bath:
Two questions:
1) A stale record is a record that has been altered by another client so your view of it is out of date?
2) If you lock a record when a client views it does that mean your client program views only one record at a time? Or do you view all records in a table and lock when the user highlights a specific row - active locking?
Regards, George
SCJP, SCJD, SCWCD, SCBCD
Originally posted by George Marinkovich:
2) I lock it when the user highlights a specific row and then indicates that he wants to book the record (for example, by pressing a Book button).
The client views all the records by default, or some subset as determined by the search criteria entered by the user.
[ January 19, 2004: Message edited by: George Marinkovich ]
Morgan
SCJP (1.4), SCJD (1.4), SCWCD (1.3), SCBCD (1.3)
Originally posted by morgan bath:
1) You lock when you book, so how long would you estimate the record will be locked for?
2) If by default you load all the records, why use a search function on the DB?
Regards, George
SCJP, SCJD, SCWCD, SCBCD
The first person to drink cow's milk. That started off as a dare from this tiny ad:
Smokeless wood heat with a rocket mass heater
https://woodheat.net
|