--- In firebird-support@yahoogroups.com, "tomkrej" <respektive@...> wrote:

>
> Hi, how did You get these times??
>
> Did You run it in IBExpert???

Yes, but i tried 2nd query with ISQL also and result is the same!

>
> If so, try to run the first query as Fetch All, maybe this is the reason.

I don't want to fetch all records!
In fact, I want to know whether there was such thing???
I tested same querys with exact db and tables in MSSQL.
Results are very faster than Firebird!

>
> Tom
>
> --- In firebird-support@yahoogroups.com, "kadriizer" <kadri@> wrote:
> >
> >
> > ------ Performance info ------
> > Prepare time = 0ms
> > Execute time = 16ms
> >
> > This query, "select * from" portion, as "select count (*) from" is changed, the performance information is as follows ...
> >
> > ------ Performance info ------
> > Prepare time = 0ms
> > Execute time = 1s 904ms
> >
> > First query is faster than second query! Why?
> >
> > Kadri.
> >
>