[cfaussie] Re: Verity spits the dummy and just a few records!
Hi Taco, Yes there are some issues with CFMX7 Verity. I spent endless hours trying to find ways to get it to work correctly. Simple. It doesn't We ended up having to index in parts. I.e. batch of 10 or 20 depending on what your doing. It was a REAL issue and still is. ITs one major issue I believe that Adobe has is that verity is crap! The free version from Apache is very good. Just takes heaps of time to setup. But once you have done it. Its all sorted. Jeremy --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Verity spits the dummy and just a few records!
We simply did a loop over it. Actually we were indexing documents. But you can use the same theory. Also in ColdFusion 7 there is a sleep function which will allow you to sleep the server until a particular process is done. This would depend on how intense the processing is. hth jeremy --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Verity spits the dummy and just a few records!
Hi Taco, in terms of Lucene (the apache version) I've been using it extensively and have nothing but raves to report. It actually doesn't need quite as much setup as it seems from the outside, and it's incredibly powerful - not to mention very very fast. If you go down that route, feel free to drop me a line if you need any help. cheers, Toby On 05/06/2006, at 11:54 AM, cfgroupie [EMAIL PROTECTED] wrote: Hi Taco, Yes there are some issues with CFMX7 Verity. I spent endless hours trying to find ways to get it to work correctly. Simple. It doesn't We ended up having to index in parts. I.e. batch of 10 or 20 depending on what your doing. It was a REAL issue and still is. ITs one major issue I believe that Adobe has is that verity is crap! The free version from Apache is very good. Just takes heaps of time to setup. But once you have done it. Its all sorted. Jeremy --- Life is poetry, write it in your own words --- Toby Tremayne Senior Technical Consultant Lyricist Software 0416 048 090 ICQ: 13107913 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Verity spits the dummy and just a few records!
I must be really out of the LOOP ;-) I cannot see how you can index a query result in parts, with a loop? Following is howwe currently do it; !--- get all content to index from the database ---cfquery name=rsResume datasource=#application.datasource#SELECT R.resumeIdentity, CASEWHEN R.candidateIdentity IS NULL THEN 0ELSE R.candidateIdentityEND AS candidateIdentity, R.resumeAsText, R.uniqueFileName, R.fileExtension, R.originalFileName, R.dateStamp , S.salutationTitle, P.firstName, P.lastName , CONCAT( COALESCE( S.salutationTitle, ), , P.firstName, , P.lastName ) AS fullNameFROM db_au_com_exclaimit.tbl_resume R LEFT OUTER JOIN db_au_com_exclaimit.tbl_candidate CON R.candidateIdentity = C.candidateIdentity!--- make sure the resume is active ---ANDR.isCurrent = 1LEFT OUTER JOIN db_au_com_exclaimit.tbl_person P ON C.personIdentity = P.personIdentityLEFT OUTER JOIN db_au_com_exclaimit.tbl_l_salutation SON P.salutationIdentity = S.salutationIdentity;/cfquery!--- update database collection --- cftrycfindexaction="" collection=col_au_com_exclaimit_query_newkey=candidateIdentitytype=customtitle=fullName query=rsResumebody=resumeAsText,fullName,originalFileName custom1=uniqueFileName /cfcatchcfset request.Error.doAppendErrorMessage( There was an error updating the collection ) / /cfcatch/cftry On 6/5/06, cfgroupie [EMAIL PROTECTED] wrote: We simply did a loop over it. Actually we were indexing documents. Butyou can use the same theory. Also in ColdFusion 7 there is a sleep function which will allow you to sleep the server until a particularprocess is done. This would depend on how intense the processing is.hthjeremy Web Design, Web development, Graphic Design and Complete Internet Solutionsan industry leader with commercial IT experience since 1994 … --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Verity spits the dummy and just a few records!
Hi Toby, that is much appreciated, I might take you up on that offer. Can you tell me; have you been indexing over a 1,000 records with Lucene? Not sure how that works, but would you use cfsearch as well to search those collections? Thanks in advance. On 6/5/06, Toby Tremayne [EMAIL PROTECTED] wrote: Hi Taco, in terms of Lucene (the apache version) I've been using itextensively and have nothing but raves to report.It actually doesn't need quite as much setup as it seems from the outside, andit's incredibly powerful - not to mention very very fast.If you godown that route, feel free to drop me a line if you need any help.cheers, TobyOn 05/06/2006, at 11:54 AM, cfgroupie [EMAIL PROTECTED] wrote: Hi Taco, Yes there are some issues with CFMX7 Verity. I spent endless hours trying to find ways to get it to work correctly. Simple. It doesn't We ended up having to index in parts. I.e. batch of 10 or 20 depending on what your doing. It was a REAL issue and still is. ITs one major issue I believe that Adobe has is that verity is crap! The free version from Apache is very good. Just takes heaps of time to setup. But once you have done it. Its all sorted. Jeremy --- Life is poetry, write it in your own words---Toby TremayneSenior Technical Consultant Lyricist Software0416 048 090ICQ: 13107913-- Taco Fleur - http://www.pacificfox.com.au Web Design, Web development, Graphic Design and Complete Internet Solutionsan industry leader with commercial IT experience since 1994 … --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Verity spits the dummy and just a few records!
Toby, I too would be interested in setting up lucene. Any code/documents you have let us know. We are seriously going to ditch Verity becuase of all the issues we have had with it Jeremy --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Verity spits the dummy and just a few records!
cfquery name=rsResume datasource=#application.datasource# SELECTR.resumeIdentity , CASE WHEN R.candidateIdentity IS NULL THEN 0 ELSE R.candidateIdentity END AS candidateIdentity , R.resumeAsText , R.uniqueFileName , R.fileExtension , R.originalFileName , R.dateStamp , S.salutationTitle , P.firstName , P.lastName , CONCAT( COALESCE( S.salutationTitle, ), , P.firstName, , P.lastName ) AS fullName FROMdb_au_com_exclaimit.tbl_resume R LEFT OUTER JOIN db_au_com_exclaimit.tbl_candidate C ON R.candidateIdentity = C.candidateIdentity !--- make sure the resume is active --- ANDR.isCurrent = 1 LEFT OUTER JOIN db_au_com_exclaimit.tbl_person P ON C.personIdentity = P.personIdentity LEFT OUTER JOIN db_au_com_exclaimit.tbl_l_salutation S ON P.salutationIdentity = S.salutationIdentity; /cfquery !--- update database collection --- cftry cfif recordcount GTE 1 cfloop query=rsResume step= from=1 to=x cfindex action=update collection=col_au_com_exclaimit_query_new key=candidateIdentity type=custom title=fullName query=rsResume body=resumeAsText,fullName,originalFileName custom1=uniqueFileName / cfcatch cfset request.Error.doAppendErrorMessage( There was an error updating the collection ) / /cfcatch /cfloop /cfif /cftry OR something like that. Jeremy --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Verity spits the dummy and just a few records!
Woops one more thing get rid of the query=rsResume My bad. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Verity spits the dummy and just a few records!
Hi Jeremy, by all means - drop me a line off list and I'll chat to you about it. cheers, Toby On 05/06/2006, at 2:18 PM, cfgroupie [EMAIL PROTECTED] wrote: Toby, I too would be interested in setting up lucene. Any code/documents you have let us know. We are seriously going to ditch Verity becuase of all the issues we have had with it Jeremy --- Life is poetry, write it in your own words --- Toby Tremayne Senior Technical Consultant Lyricist Software 0416 048 090 ICQ: 13107913 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Verity spits the dummy and just a few records!
I've used lucene to index hundreds of thousands of records without a discernable problem so far. You don't use cfsearch to search them, but you can put together some pretty simple code that will do the same job. I have a couple of cfcs that do it for me - they're somewhat customized to the apps they're a part of but it's not a big deal to make a reusable one.cheers,TobyOn 05/06/2006, at 2:10 PM, Taco Fleur wrote:Hi Toby, that is much appreciated, I might take you up on that offer. Can you tell me; have you been indexing over a 1,000 records with Lucene? Not sure how that works, but would you use cfsearch as well to search those collections? Thanks in advance. On 6/5/06, Toby Tremayne [EMAIL PROTECTED] wrote: Hi Taco, in terms of Lucene (the apache version) I've been using itextensively and have nothing but raves to report. It actually doesn't need quite as much setup as it seems from the outside, andit's incredibly powerful - not to mention very very fast. If you godown that route, feel free to drop me a line if you need any help.cheers, TobyOn 05/06/2006, at 11:54 AM, cfgroupie [EMAIL PROTECTED] wrote: Hi Taco, Yes there are some issues with CFMX7 Verity. I spent endless hours trying to find ways to get it to work correctly. Simple. It doesn't We ended up having to index in parts. I.e. batch of 10 or 20 depending on what your doing. It was a REAL issue and still is. ITs one major issue I believe that Adobe has is that verity is crap! The free version from Apache is very good. Just takes heaps of time to setup. But once you have done it. Its all sorted. Jeremy --- Life is poetry, write it in your own words---Toby TremayneSenior Technical Consultant Lyricist Software0416 048 090ICQ: 13107913-- Taco Fleur - http://www.pacificfox.com.au Web Design, Web development, Graphic Design and Complete Internet Solutionsan industry leader with commercial IT experience since 1994 … --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Verity spits the dummy and just a few records!
I'll clarify - Lucene comes as a jar file :)It's part of the apache jakarta project, but you don't need apache or anything else to use it. You can just drop the jar into your jrun classpath and away you go.TobyOn 05/06/2006, at 3:15 PM, Ryan Sabir wrote: Regarding Lucene, Does it only run on Apache? Is it possible to get it working on the Win 2003 / IIS platform? thanks. From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Toby TremayneSent: Monday, 5 June 2006 2:27 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: Verity spits the dummy and just a few records! I've used lucene to index hundreds of thousands of records without a discernable problem so far. You don't use cfsearch to search them, but you can put together some pretty simple code that will do the same job. I have a couple of cfcs that do it for me - they're somewhat customized to the apps they're a part of but it's not a big deal to make a reusable one.cheers, Toby On 05/06/2006, at 2:10 PM, Taco Fleur wrote: Hi Toby, that is much appreciated, I might take you up on that offer.Can you tell me; have you been indexing over a 1,000 records with Lucene?Not sure how that works, but would you use cfsearch as well to search those collections? Thanks in advance. On 6/5/06, Toby Tremayne [EMAIL PROTECTED] wrote: Hi Taco, in terms of Lucene (the apache version) I've been using itextensively and have nothing but raves to report. It actually doesn't need quite as much setup as it seems from the outside, andit's incredibly powerful - not to mention very very fast. If you godown that route, feel free to drop me a line if you need any help.cheers, TobyOn 05/06/2006, at 11:54 AM, cfgroupie [EMAIL PROTECTED] wrote: Hi Taco, Yes there are some issues with CFMX7 Verity. I spent endless hours trying to find ways to get it to work correctly. Simple. It doesn't We ended up having to index in parts. I.e. batch of 10 or 20 depending on what your doing. It was a REAL issue and still is. ITs one major issueI believe that Adobe has is that verity is crap! The free version from Apache is very good. Just takes heaps of time to setup. But once you have done it. Its all sorted. Jeremy --- Life is poetry, write it in your own words---Toby TremayneSenior Technical Consultant Lyricist Software0416 048 090ICQ: 13107913-- Taco Fleur - http://www.pacificfox.com.au Web Design, Web development, Graphic Design and Complete Internet Solutionsan industry leader with commercial IT experience since 1994 … --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Verity spits the dummy and just a few records!
For anyone following the thread I'd also recommend grabbing a little jar file called Luke. It's a simple little app that lets you peer directly into your indexes and run queries against them - very handy when you're debugging.cheers,TobyOn 05/06/2006, at 3:28 PM, Toby Tremayne wrote:I'll clarify - Lucene comes as a jar file :)It's part of the apache jakarta project, but you don't need apache or anything else to use it. You can just drop the jar into your jrun classpath and away you go.TobyOn 05/06/2006, at 3:15 PM, Ryan Sabir wrote: Regarding Lucene, Does it only run on Apache? Is it possible to get it working on the Win 2003 / IIS platform? thanks. From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Toby TremayneSent: Monday, 5 June 2006 2:27 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: Verity spits the dummy and just a few records! I've used lucene to index hundreds of thousands of records without a discernable problem so far. You don't use cfsearch to search them, but you can put together some pretty simple code that will do the same job. I have a couple of cfcs that do it for me - they're somewhat customized to the apps they're a part of but it's not a big deal to make a reusable one.cheers, Toby On 05/06/2006, at 2:10 PM, Taco Fleur wrote: Hi Toby, that is much appreciated, I might take you up on that offer.Can you tell me; have you been indexing over a 1,000 records with Lucene?Not sure how that works, but would you use cfsearch as well to search those collections? Thanks in advance. On 6/5/06, Toby Tremayne [EMAIL PROTECTED] wrote: Hi Taco, in terms of Lucene (the apache version) I've been using itextensively and have nothing but raves to report. It actually doesn't need quite as much setup as it seems from the outside, andit's incredibly powerful - not to mention very very fast. If you godown that route, feel free to drop me a line if you need any help.cheers, TobyOn 05/06/2006, at 11:54 AM, cfgroupie [EMAIL PROTECTED] wrote: Hi Taco, Yes there are some issues with CFMX7 Verity. I spent endless hours trying to find ways to get it to work correctly. Simple. It doesn't We ended up having to index in parts. I.e. batch of 10 or 20 depending on what your doing. It was a REAL issue and still is. ITs one major issueI believe that Adobe has is that verity is crap! The free version from Apache is very good. Just takes heaps of time to setup. But once you have done it. Its all sorted. Jeremy --- Life is poetry, write it in your own words---Toby TremayneSenior Technical Consultant Lyricist Software0416 048 090ICQ: 13107913-- Taco Fleur - http://www.pacificfox.com.au Web Design, Web development, Graphic Design and Complete Internet Solutionsan industry leader with commercial IT experience since 1994 … --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---