24.07.2014 15:14, Dimitry Sibiryakov wrote: >> I haven't tried. Did it work before? > > No.
And this is correct. >> Not everybody is working with slow networks. > > Any network is slow for transferring one record per fetch. Embedded server > shows this > problem well. (Every SELECT in it works in non-buffered mode.) Embedded is not affected by the FOR UPDATE clause. And yes, it's used in time-critical applications. >> Nope, it's a bit slower. > > Why? What's the difference? RDB$DBKEY requires a record fetch/lookup (costs at least two pages fetches plus decompression). WHERE CURRENT OF deals with the already fetched record which resides in memory. Dmitry ------------------------------------------------------------------------------ Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. http://p.sf.net/sfu/bds Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
