25.06.2014 12:52, Dimitry Sibiryakov wrote: > 25.06.2014 11:46, Roman Simakov wrote: >> 2014-06-25 12:09 GMT+04:00 Dimitry Sibiryakov <s...@ibphoenix.com>: >>> In this case why to use READ COMMITED transaction at all?.. >> >> Because opening cursor is not opening transaction. You can have long >> transaction but not opened cursors. Do not open if you are not going >> to fetch. > > I.e. a strange application developer start transaction, then, after some > time, start a > query and want to see data consistent to the moment of query start instead of > transaction > start? > May be it would be better if (s)he use brain and start transaction when > it is really > needed?..
Or may be we will implement feature "implicit transaction start" to please both user and engine ? Regards, Vlad ------------------------------------------------------------------------------ Open source business process management suite built on Java and Eclipse Turn processes into business applications with Bonita BPM Community Edition Quickly connect people, data, and systems into organized workflows Winner of BOSSIE, CODIE, OW2 and Gartner awards http://p.sf.net/sfu/Bonitasoft Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel