Hi Rick
Yes, different machines as described. Maybe machine dependent. I'd
guess not a 35 fold dependency. The improvement in speed is likely
dependent on the FB improvements made and how well the SQL is
amenable to the optimiser. I'm guessing. Another SQL select takes 2
sec for both FBs.
Russell

--- In firebird-support@yahoogroups.com, "Richard Thomas"
<rthomas@...> wrote:

>
> Hi RB:
> I'm new to FireBird Database and just downloaded and installed

1.5.3.

> Over a minute?
> 2 Seconds?
> It sounds like you ran the tests on 2 diferent machines. I'm

wondering if

> that has anything to do with the huge improvement in speed.
> Rick USA
> ----- Original Message -----
> From: "russellbelding" <russell@...>
> To: <firebird-support@yahoogroups.com>
> Sent: Saturday, April 15, 2006 4:31 AM
> Subject: [firebird-support] FB 2 (RC1) faster than FB 1.5.3
>
>
> > While converting SQL for a FB 1.5.3 to a FB 2.0 RC1 application I
> > timed three sequential select statements. One follows and the two
> > others are like it. They are used to report on done, pending and
> > overdue tasks that have been scheduled.
> >
> > select
> > USERS.USER_NAME,
> > USERS.USER_ID,
> > (select count(MATTER_EVENTS.MATTER_EVENT_ID)
> > from MATTER_EVENTS
> > join MATTERS on MATTER_EVENTS.MATTER_ID=MATTERS.MATTER_ID
> > where (MATTER_EVENTS.DATE_REQD is not null) and
> > (MATTERS.STATUS_ID=2) and
> > (MATTER_EVENTS.PERFORMER_ID=USERS.USER_ID) and
> > (MATTER_EVENTS.B_IS_ACTIVE=1) and
> > (MATTER_EVENTS.DATE_DONE is null) and
> > (cast(MATTER_EVENTS.DATE_REQD as DATE) >=
> > cast(current_date as DATE))) as theCount
> > from USERS
> >
> > FB 1.5.3 took 1 min 9 sec and FB 2.0 RC1 took 2 sec using the same
> > data on similar servers. The Server and Client were the same PC.

The

> > FB 1.5.3 PC was a 3GHz P4 and FB 2 ran on a 2.8GHz P4. Each trial
> > was ran twice with the same times.
> >
> > That is an impressive reduction in time.
> > RB
> >
> >
> >
> >
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://firebird.sourceforge.net and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
>