Ann, > > So the number of individual pages read would equal the number pages in > > the database, which means that the number of dirty pages writes should > > be less than or equal the number db pages. > > Not if some pages were forced out because the cache overflowed and then > had to be re-read.
That is reasonable and agreed, but that is not the scenario which Karol outlined. In his case, the sweep was done while no other meaningfull db activity was taking place. Separately, doesn't a sweep essentially lock up all other database activity until it is finished? If so, how would 64K of pagers reads have occurred during the sweep? Sean ------------------------------------------------------------------------------ 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
