> I am using firebird 2.5.1 from the .Net application by using the .net > provider 2.5.2. while using application, it is slowing down after > inserting around 200 record.
> Could you please let me know where the problem, same application is > running fine in SQL server 2008? > > I need some help to diagnosis the problem. A general first database performance sanity check is to run: gstat- h when things are slow to see, if OIT/OAT are way behind. As you are using 2.5, use the MON$ tables for getting a snapshot of the current database activities or the new Trace API to get a continous stream of executed events. With the Trace API you also get information on execution time, execution plan etc ... -- With regards, Thomas Steinmaurer * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php
