Subject | RE: [firebird-support] Index question |
---|---|
Author | Alex Taylor |
Post date | 2008-09-12T16:23:21Z |
Hi guys!
Thank for your answers! The final solutionis the following: I wrote 2
UDF: WORDCOUNT AND WEXTRACTWORD. They are placed in the required table's
AfterInsert,AfterUpdate, and AfterDeelete trigger. There are a separate
table, called WORDS. This contains the PK to the original table and the
extracted words in separate records of course. Both 2 columns are
indexed as well. When doing a text search, I search the WORDS table with
STARTING WITH using the index and then JOIN the original table to it. It
is lightning fast!!!!
Once again, many thanx!!!
Best regards:Alex :-)
Thank for your answers! The final solutionis the following: I wrote 2
UDF: WORDCOUNT AND WEXTRACTWORD. They are placed in the required table's
AfterInsert,AfterUpdate, and AfterDeelete trigger. There are a separate
table, called WORDS. This contains the PK to the original table and the
extracted words in separate records of course. Both 2 columns are
indexed as well. When doing a text search, I search the WORDS table with
STARTING WITH using the index and then JOIN the original table to it. It
is lightning fast!!!!
Once again, many thanx!!!
Best regards:Alex :-)