Hi André, André Knappstein, Controlling schrieb: > please be kind with me if the following advice is boring for you, but > you mentioned that you are migrating from Access.
there is nothing boring about your advice, even if I knew some of those things before ;-) > But a query like the one you posted should - under normal > circumstances - deliver records in FAR less than 5-10 seconds, even > on a slow machine and with 10.000s of records in the tables. I still struggle a bit at this, because as far as I can see, I now optimized as good as I can - without getting the desired results. > - Are you familiar with the concept of Backup/Restore in Firebird - Yes. From an Access point of view, its comparable to the compact/repair feature. > Did you read Helen's book especially on the "keep the Gap going" >(between OIT and the actual transaction) - Never heard of that. Where can I get it? > Have you checked that you do not have too many indexes, maybe with a > lot of duplicate entries. In comparison to MDBs/DBFs where a lot of > indexing was sometimes necessary to make acceptable orders, Firebird > is sometimes indeed performing better withOUT an index. - Did you > probably put different indexes on the same field? Such could make the > plan-optimizer in Firebird just go crazy. Triple-checked that. I tried without indexes, with guerilla-indexing-all tactic and carefully setting indexes only when the resulting statistic value is good enough. It did not seem to have any valuable impact on the performance. I'm stuck here. Thanks, Mathias Wuehrmann Mit freundlichen Grüßen, Mathias Wührmann FLEXact Informationssysteme -- Bernhardstr. 22 26122 Oldenburg Tel.: 0441 / 98 330 606 Fax : 0441 / 98 330 609 Web : http://www.flexact.de = <font face="arial, helvetica, sans-serif" size="10"> Mit freundlichen Grüßen,<br><br> Mathias Wührmann<br> FLEXact Informationssysteme<br> -- <br> Bernhardstr. 22<br> 26122 Oldenburg<br><br> Tel.: 0441 / 98 330 606<br> Fax : 0441 / 98 330 609<br> Web : http://www.flexact.de<br> </font> ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
