W dniu 2013-01-09 06:36:03 użytkownik Dmitry Yemanov <firebi...@yandex.ru> napisał: > 08.01.2013 21:00, liviusliv...@poczta.onet.pl wrote: > > > > 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. > > > Dmitry > >
Ok, but in my situation i suppose this should not happened with one exception if really whole index is loaded into cache.. If loaded are only index pages related to current table page then this should not happen because data in my tables go from imports and index pages are filled in the same order as table. If this is understandable.. In other words - table data contain date of import and e.g. 1 page contain 200 records created at the same time (data are not modified anywhere) and because of that index page are filled also with 200 entries ~ 1 Table Page ~1 Index Page (I know size of index entries are different then size of records but I believe that you know what I mean). If i delete data from some date count of changed pages should be small. regards, Karol Bieniaszewski ------------------------------------------------------------------------------ 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
