i move info from support list what i provide there 1. I use Super Server 64 bit 2. DB Page Size is 16k and DefaultDBPageCache is 65536 (i disable system cache in fbconfig) 3. database was backed up and restored and then i do few changes to some stored procedures and some analitics (selects) and after this i delete 25% of data from db (only deletes no inserts or updates)
> 3. database was backed up and restored > >>What did you use for gbak restore options? normal option like in flamerobin all unchecked (garbage collector work, and disabled use all space if you think about this options) also i see that db size not grow under sweep proces – then i suppose free space was enough for storing delete info – (but could be stored on the free unused pages also i do not know) >> How about indexes? Sweep will be simultaneously removing index >>entries. Could that be part of the problem? I do not know if this is important info but: l have ~4 indexes per table – but tables have not any constraints like pk, uk – and some indexes have depth 3, all others have depth 2 In database all records are small max 100 bytes - no blobs I can prepare some db for exclusive fb-team test if wishes – this take some time but is possible Karol Bieniaszewski ------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122412 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
