> 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