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
>
>
>
>
>