Derived table usage for this problem is GREAT idea! Why the ... I didn't tought that!
Thank you! On 2014.05.10. 10:26, Dimitry Sibiryakov wrote: > 10.05.2014 10:12, Molnár Attila wrote: >> OK, this just means smaller treshold rate. But with this some case you >> can gain HUGE performance boost (especially when the resultset can't fit >> into memory and have to write to disk) > Big result set is a sign of wrong application design. And in any case you > can use > derived tables to gain the same effect right now without hacking the engine. > ------------------------------------------------------------------------------ Is your legacy SCM system holding you back? Join Perforce May 7 to find out: • 3 signs your SCM is hindering your productivity • Requirements for releasing software faster • Expert tips and advice for migrating your SCM now http://p.sf.net/sfu/perforce Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel