> Just not to leave your mail without any answer: check your queries,
> analyze the plans they use, add proper indices, read books on how to
> design databases. Probably no one will tell you more unless you provide
> some details.
>
> regards
> Tomasz
>
> W dniu 2011-11-06 13:34, Mahesh Pratihari pisze:
>> Hi ALL,
>>
>>
>>
>> Could you please let me know how I can do with the Performance in
>> Firebird 2.5?
>>
>>
>>
>> Application is getting slower and slower as data is entered.

Additionally to what Tomasz has said, check the header page of your
database with gstat -h when things are getting slow.

As you are using Firebird 2.5, you have a full tool set for analyzing
such stuff already available:

* gstat -h
* Monitoring tables (MON$...)
* Trace API

Especially the Trace API can help you a lot when it comes to spotting
slow statements.


--
With regards,
Thomas Steinmaurer

* Upscene Productions - Database Tools for Developers
http://www.upscene.com/

* My Blog
http://blog.upscene.com/thomas/index.php

* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/