Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-14 Thread Tony Gravagno
> From:Bill Haskett > I think that's what Tony was talking about, but I could be wrong. %100 right, thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-14 Thread Tony Gravagno
> From: Tom Whitmore > Personally, "optimistic" locking is not an ideal > method for performing updates. I know that is the way > many DBs work but that doesn't make it right. Uh, but that IS the way that every web-based application on the planet works. C'mon now. Arguing the way things work

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-14 Thread Tony Gravagno
> From: Symeon Breen > rec.checksum = checksum(rec) > If checksum(tmp) = rec.checksum THEN Symeon, there's no doubt that coding optimistically is easy, but in addition to requiring a custom statebag you also need to manage timeouts. Wol and others have commented on some of the nuances here.

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-14 Thread Bill Haskett
m *To:* 'U2 Users List' *Date:* 7/14/2011 5:27 AM *Subject:* Re: [U2] Record Locks - How long should they last for? (Opinion) Because it is just 2 lines of code anyway so why bother -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserv

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-14 Thread Symeon Breen
END So maybe 3 or 4 lines -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: 14 July 2011 13:41 To: 'U2 Users List' Subject: Re: [U2] Record Locks - How long should they last for

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-14 Thread Symeon Breen
to use for acces) and then do the correct procedure to read/write - a chunk of code in there so i wont include it in here, but it does mean all reads and writes go through that one piece of code... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@li

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-14 Thread Wols Lists
On 14/07/11 13:40, David Wolverton wrote: > Perhaps a more interesting example might be -- what if your business model > would make it more efficient to move one of the files 'off world' to a SQL > store on another machine?? If you 'called' a subroutine to do your reads > and writes, those could a

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-14 Thread David Wolverton
al Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, July 14, 2011 7:28 AM To: 'U2 Users List' Subject: Re: [U2] Record Locks - How long should they last for? (Opinion) Because it is just 2 lines of co

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-14 Thread Symeon Breen
long should they last for? (Opinion) After all of these years, why o why haven't the MV DBMS vendors created a READUO mechanism which allows us to optimistically lock records in exactly the way that George, Rex, and a hundred other app developers have indicated over the last 15 years? Desig

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-14 Thread Tom Whitmore
riginal Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Ferris Sent: Wednesday, July 13, 2011 10:47 PM To: U2 Users List Subject: Re: [U2] Record Locks - How long should they last for? (Opinion) "why haven't the MV DBM

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-13 Thread Ross Ferris
lto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Thursday, 14 July 2011 8:46 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Record Locks - How long should they last for? (Opinion) After all of these years, why o why haven't the MV DBMS vendors created a READ

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-13 Thread Kevin King
Ah... thank you for clarifying - and gently at that! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-13 Thread Bill Haskett
ut, but I could be wrong. Bill - Original Message - *From:* precisonl...@gmail.com *To:* U2 Users List *Date:* 7/13/2011 4:35 PM *Subject:* Re: [U2] Record Locks - How long should they last for? (Opinion) Tony, wouldn&

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-13 Thread Kevin King
Tony, wouldn't READL in Unidata count? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-13 Thread Tony Gravagno
After all of these years, why o why haven't the MV DBMS vendors created a READUO mechanism which allows us to optimistically lock records in exactly the way that George, Rex, and a hundred other app developers have indicated over the last 15 years? Design tip: For all new development, abstract you

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-13 Thread Dawn Wolthuis
We use "optimistic locking" with a version number in each record (in our case Cache' handles the versioning based on our specification of the files, but either versioning or checksums works). This is a solid approach for web apps instead of using pessimistic locking. --dawn On Wed, Jul 13, 2011 a

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-13 Thread John Hester
od. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, July 13, 2011 10:28 AM To: U2 Users List Subject: Re: [U2] Record Locks - How long should they last for? (Opinion) > -Ori

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-13 Thread George Gallen
> -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Rex Gozar > Sent: Wednesday, July 13, 2011 1:08 PM > To: U2 Users List > Subject: Re: [U2] Record Locks - How long should they last for? > (

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-13 Thread Rex Gozar
Based on your description, you are using a pessimistic locking approach (similar to a telnet user) for a web application, so choosing a timeout would be arbitrary. Your "heartbeat" idea could be tied in to avoid having to manually release records. It seems like a bad idea to force a connectionles

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-13 Thread BobW
It would depend on what the application was on the web server. I'd think about the security issues a bank has and how long it was before their sessions "timeout" and require you to re-login. Then you have the consideration of how long a user might take to "complete" a transaction, such as dating