It is not the search that is the major load, it is the indexing. Using
MSSQL, one can set the indexing to be performed in the background, and
also triggered by changes in the indexed table. AFAIK, Verity needs to do
full indexes each time, which can take quite some time. (NB. I don't have
any experience with Verity above CF4)
-------------------------------------------------------------
Hugo Ahlenius E-Mail: [EMAIL PROTECTED]
Project Officer Phone: +46 8 230460
UNEP GRID-Arendal Fax: +46 8 230441
Stockholm Office Mobile: +46 733 467111
WWW: http://www.grida.no
-------------------------------------------------------------
| -----Original Message-----
| From: Calvin Ward [mailto:[EMAIL PROTECTED]
| Sent: Monday, June 30, 2003 12:48
| To: CF-Talk
| Subject: Re: UDF for MSSQL full-text searches
|
|
| I don't think that MSSQL full text causes any more of a load
| than Verity
| does.
|
| - Calvin
|
| ----- Original Message -----
| From: "Robertson-Ravo, Neil (RX)"
| <[EMAIL PROTECTED]>
| To: "CF-Talk" <[EMAIL PROTECTED]>
| Sent: Monday, June 30, 2003 5:37 AM
| Subject: RE: UDF for MSSQL full-text searches
|
|
| > not sure about 4, but verity can certainly search within a
| Database....
| >
| > I must admit, I have never had to use the full text
| searches as our server
| > guys dont like the load they cause.
| >
| > -----Original Message-----
| > From: Hugo Ahlenius [mailto:[EMAIL PROTECTED]
| > Sent: 30 June 2003 10:41
| > To: CF-Talk
| > Subject: RE: UDF for MSSQL full-text searches
| >
| >
| > Yes, cause verity (at least in CF 4, which we are partly
| on) can't search
| > things in the database. And the MSSQL full-text indexing
| seems very good
| > to me!
| >
| >
| >
| >
| > -------------------------------------------------------------
| > Hugo Ahlenius E-Mail: [EMAIL PROTECTED]
| > Project Officer Phone: +46 8 230460
| > UNEP GRID-Arendal Fax: +46 8 230441
| > Stockholm Office Mobile: +46 733 467111
| > WWW: http://www.grida.no
| > -------------------------------------------------------------
| >
| >
| >
| >
| >
| >
| > | -----Original Message-----
| > | From: Robertson-Ravo, Neil (RX)
| > | [mailto:[EMAIL PROTECTED]
| > | Sent: Monday, June 30, 2003 11:13
| > | To: CF-Talk
| > | Subject: RE: UDF for MSSQL full-text searches
| > |
| > |
| > | Have you ruled out Verity?
| > |
| > | -----Original Message-----
| > | From: Hugo Ahlenius [mailto:[EMAIL PROTECTED]
| > | Sent: 30 June 2003 10:17
| > | To: CF-Talk
| > | Subject: UDF for MSSQL full-text searches
| > |
| > |
| > | Hi,
| > |
| > | I am using the MSSQL full-text indexes for searching in a
| > | database from a
| > | webpage. Is there an UDF out there that would 'bake' in data
| > | for that, or
| > | is there a simple way to solve this with regexps... ? If not,
| > | I would have
| > | to look into that myself (if not regexps, the string needs to
| > | be looped).
| > |
| > | If the form contains:
| > | apple pear
| > | I would like the UDF to convert it to:
| > | apple NEAR pear
| > |
| > | If the form contains:
| > | apple AND pear (or instead of AND, NEAR or OR)
| > | I would like the UDF to keep that.
| > |
| > | If the form contains:
| > | "apple pear"
| > | I would like the UDF to keep that.
| > |
| > | Here comes the tricky bit:
| > | If the form contains:
| > | apple "pear peach"
| > | I would like the UDF to convert it to:
| > | apple NEAR "pear peach"
| > |
| > | (i.e. it shouldn't touch anything inside quotes)
| > |
| > | Any help?
| > |
| > | /Hugo
| > |
| > |
| > |
| > | -------------------------------------------------------------
| > | Hugo Ahlenius E-Mail: [EMAIL PROTECTED]
| > | Project Officer Phone: +46 8 230460
| > | UNEP GRID-Arendal Fax: +46 8 230441
| > | Stockholm Office Mobile: +46 733 467111
| > | WWW: http://www.grida.no
| > | -------------------------------------------------------------
| > |
| > |
| > |
| > |
| > | ###########################################
| > |
| > | This message has been scanned by F-Secure Anti-Virus for Microsoft
| > | Exchange.
| > | For more information, connect to http://www.F-Secure.com/
| > |
| > |
| > |
| >
| >
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
