Ultraseek (Verity's big brother) may be another place to look. Also,
there's a project called CFLucene that helps with a lot of the Java
Lucene stuff you might want to check out. I played with it a little last
week for a project, but didn't get too deep into it. I did find that in
order to use the examples, you have to get the source from the SVN repo.
However, with 2 million records, you'll probably want to get in there to
partition the indexes. I think I remember reading somewhere that there
is about a 2GB limit on the index so you'll most likely need to
implement a MultiSearcher.
Wayne
David Ross wrote:
MSSQL has a built-in full-text search engine on certain versions - that
may be the easiest thing to do. I think 2 million entries is beyond what
the Verity that comes with CF allows, but you could look into a separate
Verity license or Lucene, an open-source alternative.
-Dave
[EMAIL PROTECTED] 04/26/06 1:24 PM >>>
I have a MSSQL server database with approx 2 million records. I would
really like a simple 'Google Like' interface search for my clients
that would search for the given value in all fields of all those
records.
I have been looking a the Google Search Appliance, which has direct
database indexing built in, but it is VERY expensive (min $30K). I
have also seen the 'Google Mini' whichosts less ($2K) but does not do
the direct database indexing. Instead I have seen the reccomendation
that I build a dynamic page with URL links to each record. Would this
work with sow many records involved?
Has anyone seen or does anyone have any ideas on making the entire
contects of a large database easily searchable?
TIA,
--
David Mineer Jr
---------------------
The critical ingredient is getting off your butt and doing
something. It's as simple as that. A lot of people have ideas,
but there are few who decide to do something about them now.
Not tomorrow. Not next week. But today. The true entrepreneur
is a doer.
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] with the words 'unsubscribe cfcdev' as the subject of
the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
(www.cfxhosting.com).
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
-----------------------------------------
CONFIDENTIALITY NOTICE: This email and any attachments may contain
confidential information that is protected by law and is for the
sole use of the individuals or entities to which it is addressed.
If you are not the intended recipient, please notify the sender by
replying to this email and destroying all copies of the
communication and attachments. Further use, disclosure, copying,
distribution of, or reliance upon the contents of this email and
attachments is strictly prohibited. To contact Albany Medical
Center, or for a copy of our privacy practices, please visit us on
the Internet at www.amc.edu.
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] with the words 'unsubscribe cfcdev' as the subject of the
email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
(www.cfxhosting.com).
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
--
Wayne Graham
Earl Gregg Swem Library
College of William and Mary
PO Box 8794
Williamsburg, VA 23185
757.221.3112
http://swem.wm.edu/blogs/waynegraham/
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] with the words 'unsubscribe cfcdev' as the subject of the
email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
(www.cfxhosting.com).
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
