On Wed, 30 Nov 2011 09:14:05 +0530, "Mahesh Pratihari"
<mahesh.pratihari@...> wrote:

> Hi All,
>
> Application is very slow while connecting Firebird database version
> 2.5.0 using the .Net Provider 2.5.1.

You will need to provide more information than this. What exactly is slow?
Connecting or using the database? How slow is it (as in what operations
take how many milliseconds etc)? Is your application using one connection
or multiple connections? Are you pooling connections or opening them when
you need and closing again when done? Are you running Firebird as classic
or superserver?

> Please have a look at the snap shot of database what I am using. I have
> changed the Page buffers size from default 0 to 4000 to check the
> performance of the database, but I could not get any thing extra.

Can't look at your database: the mailinglist does not accept attachments.
If pagebuffers is set to 0, Firebird uses the default specified in
firebird.conf. Depending on the exact server configuration used, 4000 could
be excessive.

> Shall I do anything else with the firebird.conf file for setting up the
> database? While installing the database, it is taking default value and
> I have not done any setup for this, if it require please guide me how I
> ca do that.Please guide me how to achieve the better performance in
> firebird. Same application is running fine while connecting the SQL
> server 2008.
>
> Please let me know if you want anything about database, for checking the
> performance of it.

It would be helpful to show the output of gstat -h (see
http://www.firebirdsql.org/manual/gstat-example-header.html#d0e32928 )

Mark