--- In firebird-support@yahoogroups.com, "Adam" <s3057043@...> wrote:

>
> --- In firebird-support@yahoogroups.com, "sathiesh81"
> <sathiesh81@> wrote:
> >
> > --- In firebird-support@yahoogroups.com, "Adam" <s3057043@> wrote:
> > >
> > > --- In firebird-support@yahoogroups.com, "sathiesh81"
> <sathiesh81@>
> > > wrote:
> > > >
> > > > Hi
> > > >
> > > > Recently i updated firebird 2.0 (version: WI-V2.0.0.12748) in
> my
> > > > machine and i found the processing time on firing a query
> (simple or
> > > > complex query) consumes more time than that of the earlier
> Firebird
> > > 2.0
> > > > versions. please suggest me any solutions...
> > >
> > > Don't hold your breath. You have provided no information, so
> please
> > > either provide more information or ask on the firebird-mind-
> readers
> > > list.
> > >
> > > Adam
> > >
> > earlier i used Firebird 2.0 Beta 1(gds32.dll version

2.0.0.11675).

> now
> > i am using Firebird 2.0(gds32.dll version 2.0.0.12748). will this
> make
> > any difference in speed?
> >
>
> A lot of things were fixed, there were 3 betas and 5 release
> candidates, so it is entirely possible. But you still have not told
> us anything about your database structure, the query you are
> measuring or the shape of the data, which makes it very difficult

to

> suggest things to try.
>
> Adam
>

I have a database inwhich a table(having 11 fields, all have datatype
as float) has more than 30lakh of records and I have an application
that shows the number of records fetched per sec from the same table.
Usually it is from 10,000 to 12,000. i am using Firebird-2.0-
Candidate-5-Win32(gds32.dll version 2.0.0.11675).
After installing new version of GDS32.DLL 2.0.0.12748 I noticed that
fetching speed slowsdown and become 2,200 to 2,500 records per
second. Problem disappears if i replace the gds32.dll in system32
directory.