Sean,
> 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. > No, not quite, but close. It wouldn't read old TIPs. It might not read some blob pages if the blobs were staying, and similarly data pages containing only the tails of records larger than a page. But essentially, yes, it reads 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. > Not if some pages were forced out because the cache overflowed and then had to be re-read. That could happen if the records were stored with random values in the index keys.. For example, the first index leaf page was read first, then not changed while 64K other pages were changed so it got flushed out, then the next record to be garbage collected had a key stored on that first page, so it was read in again, changed, and that cycle repeated. But in this case all four indexes (really ?) have keys that increase in newer records. Very perplexing. Ann > > > 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 > -- Cheers, Ann
------------------------------------------------------------------------------ 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
