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