09.01.2013 20:52, Leyne, Sean wrote: > > In his case, the sweep was done while no other meaningfull db activity was > taking place.
It doesn't matter. > Separately, doesn't a sweep essentially lock up all other database activity > until it is finished? Nope. > If so, how would 64K of pagers reads have occurred during the sweep? Sweep jumps between data and index pages per every record. If the cache is full of dirty pages and pages are more or less randomly distributed, many such jumps will get a cache miss and force a page write followed by a page read. Dmitry ------------------------------------------------------------------------------ Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery and much more. Keep your Java skills current with LearnJavaNow - 200+ hours of step-by-step video tutorials by Java experts. SALE $49.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122612 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
