Thanks Nigel,
because schema design is so important for preformance I thought it was
approriate here.
Since there is a thread on Firebird-support I will move my question
over there.
Cheers !

Bruceb

--- In Firebird-Architect@yahoogroups.com, "Nigel Weeks" <nweeks@e...>
wrote:

> This is more suited for the firebird-support list.
>
> Firebird's speed, as with all databases, depends on schema design.
>
> Full text searching using the supplied tools(CONTAINING, LIKE) often

results

> in full-table scans, which can take longer than expected.
>
> That said, there's a thread on firebird-support about adding a full-text
> index as a separate table, which might suit your requirements.
>
> Search the archives for "near-match search". I'm releasing working

code for

> it very soon.
>
> Nige.
>
> > -----Original Message-----
> > From: Firebird-Architect@yahoogroups.com
> > [mailto:Firebird-Architect@yahoogroups.com] On Behalf Of
> > bruce_bacheller
> > Sent: Tuesday, 3 May 2005 10:02 AM
> > To: Firebird-Architect@yahoogroups.com
> > Subject: [Firebird-Architect] Large catalogs and Full Text Indexing
> >
> > Anybody have any info on how how good is firebird for speed
> > with large catalogs and how rich is its FULL TEXT indexing support?
> >
> > For instance about a 15 million SKU catalog ?
> >
> > Thanks in advance for a quick reply.
> >
> > Bruceb
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > __________ NOD32 1.1086 (20050502) Information __________
> >
> > This message was checked by NOD32 antivirus system.
> > http://www.nod32.com
> >
> >