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
|
|
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_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
-------------------------------------------------------------
