RE: [ACFUG Discuss] Verity and Blobs
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 discussion@acfug.org To discussion@acfug.org cc Subject RE: [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: discussion@acfug.org 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_Documentationfile=1303.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 -
Re: [ACFUG Discuss] Verity and Blobs
We run Winblows here, its not too hard to use FDS to synch servers up. I have used this before, both boxes need to belong to a domain and all with a DC and AD and that's enough acronyms for now. Another option that might be quicker then fighting with blobs is the event gateway and the filewatcher that comes with CF7provided you have upgraded that is. By the way how are you linking to this file? If using HTTP://.com/file.doc no problem, eh?DKOn 8/14/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: 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 discussion@acfug.org To discussion@acfug.org cc Subject RE: [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: discussion@acfug.org 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_Documentationfile=1303.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 - -- Douglas Knudsenhttp://www.cubicleman.comthis is my signature, like it? - 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 -
Re: re[2]: [ACFUG Discuss] Verity and Blobs
We are hoping to be on 7 by the time this launches. There is more than just Verity collections that need to be up to date. People need to be able to download the files as well (from the application itself). mcg Mischa Uppelschoten ext 10 [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/14/2006 12:32 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject re[2]: [ACFUG Discuss] Verity and Blobs 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 discussion@acfug.org [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: discussion@acfug.org 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_Documentationfile=1303.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
[ACFUG Discuss] Verity and Blobs
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 -
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_Documentationfile=1303.htmOn 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 Rossweb 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 -
RE: [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: discussion@acfug.org 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_Documentationfile=1303.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 -
