I'm using this process to index an 11.5Mb Access DB with 65,000 records. It
takes an IBM Netfinity server with 500Mb of RAM to create the index - blue
screen of death on anything else - but works well once created.
-----Original Message-----
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 18 May 2000 4:13 AM
To: [EMAIL PROTECTED]
Subject: Re: Cold Fusion Search tools
Initially, you create the verity collection by creating a query, and running
cfcollection against that query. You only need to run this once (of course,
you will need to run it again when the db is update, or schedule this
template to run at regular intervals)
Then you can use cfsearch without having to run the query/cfcollection
everytime you're running the search. Make sure that you're putting cfsearch
on a separate page, and make sure that you create the collection before you
run your cfsearch for the first time.
Now, if you need to perform a search on the db in real time, Verity's not
the answer. Easy enough, however, to "almost" query in real time: everytime
you update/insert to the db, you re-run your collection page (of course,
that can be a bit excessive depending on your situation, but that's another
discussion).
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
