Search for text in Database
From: Greg Cyrus <nospam_at_muelltonne.de>
Date: Wed, 6 Oct 2004 20:49:53 +0200
Message-ID: <ck1esh$d9o$02$1_at_news.t-online.com>
Hi,
I would like to use keywords inside a record to search for - searchengine-functionality
How can I design the table? Right now I would store data in CLOB/BLOB or Memo-Column in a format like ";apple;banana;lemon;". I would use a INSTR(ring)-function - but I wonder if the performance is still OK then - even when I index the field. Are there maybe even better ways?
Date: Wed, 6 Oct 2004 20:49:53 +0200
Message-ID: <ck1esh$d9o$02$1_at_news.t-online.com>
Hi,
I would like to use keywords inside a record to search for - searchengine-functionality
How can I design the table? Right now I would store data in CLOB/BLOB or Memo-Column in a format like ";apple;banana;lemon;". I would use a INSTR(ring)-function - but I wonder if the performance is still OK then - even when I index the field. Are there maybe even better ways?
Thanx in advance.
Greg
Received on Wed Oct 06 2004 - 20:49:53 CEST