A Verity collection is nothing but a bunch of files on disk. Unless you care a lot about adding documents to your collection "real time", you could change the upload procedure to always upload to one box, refresh your collections on that box and then copy the collections to the other box.
If you're running CFMX7 there's a file "monitor" gateway that fires an event when a new file is detected somewhere. If not, I guess it depends on the server OS as far as syncing options. /m > Just looking at all the options. One issue with the current system is a record goes in the database for a file, but is stored as a file on the web server. Unfortunately, we are running a cluster of 2 servers and a file gets uploaded to ONE of the two servers. (They are working on some sync software and currently I don't have the time to write a 'fix') No, there's not a third server out there that I can put files on. I am just looking at options (and reasons not to put files in the database, which I don't like doing either). We are running Oracle. Anyone integrated with Northern Lights search software? That might also be a possibility, but I've never used it before. Thanks, mcg John Mason <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/11/2006 01:32 PM Please respond to [email protected] [EMAIL PROTECTED] cc SubjectRE: [ACFUG Discuss] Verity and Blobs There are two main uses of verity. 1) Searching files in a directory structure (cfm, pdf, doc, etc) 2) Searching specific text in database sources (like in sourcing items in text or ntext fields) Verity is simply a smaller index database pointing to where the searches are pointing to. Why are they wanted to put the documents into the database? Are they running Sql Server or Oracle to do this? John [EMAIL PROTECTED] From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Ross Sent: Friday, August 11, 2006 12:24 PM To: [email protected] Subject: Re: [ACFUG Discuss] Verity and Blobs hmm.. I'm not sure on that one... in my experience with verity I didn't choose that direction. I just stored the files outside of the web docroot and indexed them normally. I have an aversion to storing files in the db... I would think it would slow verity down a bit pulling all that data from the db. If Verity can't index files that are stored in the db you may have to end up writing a query to dump all the data to the file system and then run your indexer (now that would be painstaking). The livedocs don't really reveal an answer to you question. http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=00001303.htm On 8/11/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: We are looking at potentially storing files in the database. I'm not a big fan of that, but it's a possibility. Can Verity index files if they are in the database? Thanks, mcg ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink ------------------------------------------------------------- -- Steven Ross web application & interface developer http://www.zerium.com [phone] 404-488-4364 ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink ------------------------------------------------------------- < Mischa Uppelschoten The Banker's Exchange, Inc. 2020 Hills Avenue NW Atlanta, GA 30318 Phone: (404) 605-0100 ext. 10 Fax: (404) 355-7930 Web: www.BankersX.com Follow this link for Instant Web Chat: http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
