RE: Search engine

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 28 May 2003 13:09:45 -0800
Message-ID: <F001.005A4E20.20030528130945@fatcity.com>

Tammy

• For a small amount of searching, take a look at function-based indexes (you just said usernames).
• You can also create your own method with PL/SQL pretty easily. Strip individual words into a separate table that can be easily searched.
• For heavy-duty searching, look at Oracle Text (interMedia Text in Oracle8i) http://technet.oracle.com/products/text/content.html
• Don't use ColdFusion. It is easy but difficult to scale. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, May 28, 2003 3:45 PM
To: Multiple recipients of list ORACLE-L

Could someone give me some information or lead on how I can create a search engine for usernames. I am running an 8.1.7.4 database and also 9ias for my web application. I have received some info such as to create the code in ColdFusion and link up to the database with ODBC. Does anyone have any other possibility?

Thanks,

Tammy R. Jordan
Morehouse College
tjordan_at_morehouse.edu

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Tammy Jordan
  INET: tjordan_at_morehouse.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed May 28 2003 - 16:09:45 CDT