I have a full text cataolog that was populating when I left work. Had been running for a couple of hours. I will continue to explore this option tommorrow. I will have to look into verity more. I know of that but have never used it, except as part of the old Allaire Forums that I once used.
Thanks. 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] > > > -- 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]
