You probably need to add an index to the field 'Create Date' to be able to search againts a table with that amount of records...
Or use some of the other indexed fields in the where clause. -- Jarl 2008/6/12 Ravi <[EMAIL PROTECTED]>: > Hi: I am running ars_GetListEntryWithFields against AR System EMail > Messages form which has a lot of data (550993 records). I want to > perform some checking on the BCC field and decide if I can delete the > entry. But everytime I run the script I get the > > GLEWF Failed: [ERROR] Message not in catalog; Message number = 94 > (199.11.3.12) (ARERR #94) at ./cleanup_arsystememail.p.pl line 39. > > The AR Error document says the query is timing out. I am using the > Create Date: < time as the qualifier. My oldest record has a create date > of 12/10/2007 0:0:26. I have tried running the script with a date as old > as that. > > Any suggestion. Below is the actual code. > > $thTime = time() - ($days*3600); > $qual_str = "'Create Date:' < $thTime"; > ($qual = ars_LoadQualifier($ctrl, $schema, $qual_str)) || die > "ars_LoadQualifier: $ars_errstr"; > > @get_list_fields = (18089,18090,1,3); > (@Entries = ars_GetListEntryWithFields($ctrl, $schema, $qual, 0,0, > [EMAIL PROTECTED],1, 1) ) || die( "GLEWF Failed: $ars_errstr" ); > > > TIA > Ravi > > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > Arsperl-users mailing list > Arsperl-users@arsperl.org > https://lists.sourceforge.net/lists/listinfo/arsperl-users > ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ Arsperl-users mailing list Arsperl-users@arsperl.org https://lists.sourceforge.net/lists/listinfo/arsperl-users
