Dmitry, > > I understand that i can get more reads becouse of "small" cache but > > why writes? > > Every read into a cache full of dirty pages (modified by sweep) implies a page > write, because the engine needs to reuse some page buffer for reading.
That is reasonable, but many times more writes are occurring. Let's assume that the cache is full of dirty pages before the start of the sweep. The sweep would end up reading all of the pages in the database. 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. 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
