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]
