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?.. -- WBR, SD. ------------------------------------------------------------------------------ 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
