The fake query thing rocks... it'll reduce the time it take to index by loads and loads... the performance benefits are well worth it.
----- Original Message ----- From: "Douglas Humphris" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 22, 2003 3:57 PM Subject: RE: [ cf-dev ] VERITY PROBLEMS Hi Tomo, Yeah I've tried re-creating the collections. I've also thought about the fake query thing but haven't tried it yet - don't really want to... Thanks, Douglas -----Original Message----- From: Tomo Smith [mailto:[EMAIL PROTECTED] Sent: 22 October 2003 15:38 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] VERITY PROBLEMS you could try deleting the collection then recreating it, either programmatically or through cfadmin. Also it might be a good idea to purge this one first and see if that helps any... Another thing you could think of doing (only if you're using module recursion to get all the records from the database back - if you have multiple child parent nodes) is to copy the query results to a fake query, and only when you have all the results back then update the collection with the fake query, rather than opening a whole can of verity threads!... Hope all of that makes sense, Tom ----- Original Message ----- From: "Douglas Humphris" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 22, 2003 3:29 PM Subject: [ cf-dev ] VERITY PROBLEMS Hi folks, I'm having a nightmare today trying to get a verity search collection to return results. I haven't used them for quite a while. I've got a search collection (Reg_enq) which is built from a recordset. After running cfindex I get a collection of about 8Mb in size. When I try cfsearch on that collection it never returns any results. Also, when I try cfsearch on multiple collections it returns no results. The other collections are all built from a directory tree and they return results fine when searched by themselves. Here's the code for cfindex: cfindex action="REFRESH" collection="#SearchCollection#" key="ID" type="CUSTOM" title="Title" query="GetRegEnq" body="Inquiry, Title" custom1="reg_enq" Appears to work fine, but when I cfdump the results of: cfsearch name = "GetResults" collection = "#FORM.Collections#" criteria = "#SearchCriteria#" startrow = "#FORM.StartRow#" the resultset is empty. Any ideas, pointers would be much appreciated. Thanks, Douglas PS This is old CF3.5 code which I'm migrating to CF5 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
