I was following this debate .....
Is Firebird/Interbase that slow ? How does it really compare to MySql
or Ms Sql Server ?

Decision to come ..

Thanks
===============================

bortoswatkins wrote:

> --- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
> wrote:
> > > --- In firebird-support@yahoogroups.com, "Alan McDonald"
> <alan@m...>
> > > wrote:
> > > > > Here is the DDL from the FB 1.03.
> > > > >
> > > > > CREATE TABLE LEDGER (
> > > > > ID DOUBLE PRECISION NOT NULL,
> > > > > ENTERED_DATE TIMESTAMP,
> > > > > EFFECTIVE_DATE TIMESTAMP,
> > > > > CATEGORY_ID DOUBLE PRECISION,
> > > > > DESCRIPTION VARCHAR(50),
> > > > > COMPANY_ID DOUBLE PRECISION,
> > > > > LEDGER_TYPE DOUBLE PRECISION,
> > > > > CLEARED CHAR(1),
> > > > > MEMO VARCHAR(1000),
> > > > > CHK_AMT NUMERIC(9,2),
> > > > > DEPOSIT_AMT NUMERIC(9,2),
> > > > > USERID SMALLINT);
> > > > >
> > > > > ALTER TABLE LEDGER ADD CONSTRAINT ILEDGER_ID PRIMARY KEY (ID);
> > > > >
> > > > > CREATE INDEX ILEDGER_CATEGORY_ID ON LEDGER (CATEGORY_ID);
> > > >
> >
> > Can you put some indexes on these date fields please and see what
> shange
> > there is?
> > Even if they are only all ascending indexes it will be faster -
> maybe
> > descending as well.
> > Alan
>
> I have tried indexing every field, as well as adding fields to the
> index you see above, with no improvement.
>
>
> ------------------------------------------------------------------------
> *Yahoo! Groups Links*
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>