Yes, 3 is a good way if transactionsa are very "short" (transaction per operation aka autocommit), it solves deadlock problem and most of conflicts ( optimistic loclking can solve the rest ). But I do not think all of applications can use this way, most of my applications can't. Think about Gavin's example ( some of my applications use messaging too) , most of my applications are integrated with "legacy" systems, some of them use "import" it takes ~2 min. to import some files, but transactions can not wait for this import ( sometimes of transactions are orders in stock exhange ). If you are talking about applications like "Web blog", Prevayler must be a good choise.
> > "Juozas Baliuka" <[EMAIL PROTECTED]> writes: > > Databases lock updated and deleted rows only and transaction blocks > > on conflict only, it never block query or not conflictiong updates, > > I see three ways to solve update conflict: > > > 1) block transaction > > 2) abort transaction > > 3) no concurent transactions > > > Looks like 3 is prefered in Prevayler, is not it ? > > Right. Interestingly, there is no performance hit to (3) *if* all > your data is in memory. Oracle is a multi-billion dollar company > mainly because this is rarely a valid assumption. > > I'm wondering if a weaker assumption (only live data must be in > memory) would work for a somewhat larger portion of the applications > people are using databases for. > > - a > > -- > "Education is not filling a bucket but lighting a fire." -- WB Yeats > > > ------------------------------------------------------- > This SF.net email is sponsored by: SF.net Giveback Program. > Does SourceForge.net help you be more productive? Does it > help you create better code? SHARE THE LOVE, and help us help > YOU! Click Here: http://sourceforge.net/donate/ > _______________________________________________ > hibernate-devel mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/hibernate-devel ------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you be more productive? Does it help you create better code? SHARE THE LOVE, and help us help YOU! Click Here: http://sourceforge.net/donate/ _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel