:-)
I've heard that using SQL Server's capabilities is the way to go.
On 4/26/06, David Ross <[EMAIL PROTECTED]> 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]
----------------------------------------------------------
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]
