Hugo, Note that I wasn't speaking about searching.
Correct about MSSQL, in either case, both solutions require that the database be indexed with some degree of frequency, the amount of that freqency is dependent upon your need for accuracy in real time. However, Verity will be creating load on both the database server it is indexing and the coldfusion server it resides on. Whether this is better overall than the MSSQL indexing, will depend on a number of factors regarding a specific environment. - Calvin ----- Original Message ----- From: "Hugo Ahlenius" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, June 30, 2003 6:52 AM Subject: RE: UDF for MSSQL full-text searches > 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
