What kind of query response time are you experiencing under heavy load? I'm just now getting into the verity side of things because I am building a search engine for a client and am curious as to how much of an increase in speed the collection makes over just making a query that hits the sqlserver db. I know it's better but I don't know how much.
If you have any pointers or pitfalls to avoid I'd appreciate that as well. Thanks, Jason -----Original Message----- From: Everett, Al [mailto:AEverett@;askallied.com] Sent: Friday, November 15, 2002 8:36 AM To: CF-Talk Subject: RE: Verity index of a query Yeppers. CF4.5 before that. > -----Original Message----- > From: Dowdell, Jason G [mailto:DowdelJG@;usano.ksc.nasa.gov] > Sent: Friday, November 15, 2002 8:35 AM > To: CF-Talk > Subject: RE: Verity index of a query > > > I'm assuming you're running CF5 with the out of the box > Verity engine? Just curious. > > Thanks for the feedback, > Jason > > -----Original Message----- > From: Everett, Al [mailto:AEverett@;askallied.com] > Sent: Thursday, November 14, 2002 3:58 PM > To: CF-Talk > Subject: RE: Verity index of a query > > > Heck no. We reindex a database of 290,000 products weekly. > The collection is > stored on disk. > > > -----Original Message----- > > From: Angel Stewart [mailto:gel@;silkcotton.com] > > Sent: Thursday, November 14, 2002 3:39 PM > > To: CF-Talk > > Subject: RE: Verity index of a query > > > > > > I believe it is stored in coldfusion/verity/collections on > the server. > > > > I don't think you are required to re-index a database verity > > collection > > everytime you reboot your server... > > > > -Gel > > > > > > -----Original Message----- > > From: Dowdell, Jason G [mailto:DowdelJG@;usano.ksc.nasa.gov] > > > > Does anyone know how/where a Verity index of a query > > is stored on the box? I'm wondering if the server is > > restarted whether > > or not the indexed query will remain or if it's stored in the > > CFServer's > > memory until that box shuts down... At which point the index > > would need > > to be recreated. > > > > Points to note: I am calling a query that gets stored by verity an > > "index". I'm not sure if I should use the word "collection" > > here since > > it's not a "collection" of docs. When I say "index" I'm not > > referring to > > the primary or foreign key nature of the database. (just wanted to > > clarify) > > > > Thanks, > > Jason > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
