>>Dmitry Yemanov commented on CORE-5025: >>It depends on the query, I've seen cases from zero difference up to 40%. >>The worst case is when everythng is cached and the query is as trivial as >>select count(*) from table. I suspect that the page cache is not the only >>code guilty for that but its impact >>is the most noticable. It's somewhat >>explained here: >>http://www.slideshare.net/mindthebird/superserver-in-firebird-3. If you >>have some time to spend with the profiler, it would be much appreciated, >>we may still have some room for improvement.
Hi, i must ask about slide 16 How this work. 1. It iterate page by page all of this operations? or 2. lock is accuired on hash table and here is some iteration e.g. 1000 processed records (100 pages ..., or something) and after that lock is released to other threads? If the first option - it is a very expensive operation and should be changed. Interbase have e.g. parameter in config - gain control to another thread after processing 1000 records. regards, Karol BIeniaszewski ------------------------------------------------------------------------------ Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK. Use one codebase in this all-in-one HTML5 development environment. Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs. http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
