Re: [Arsperl-users] Queries on 'HPD:HelpDesk' taking too long.

[Thilo S. <thi...@ap...>]

I'd recommend not to use the OO interface.
$f->openForm loads all field properties of HPD:Helpdesk, which is 
entirely unnecessary for your query.

It might also be better to use one ars_GetListEntryWithFields call 
instead of ars_GetListEntry and separate ars_GetEntry calls.

People have reported problems with field names in queries, so you might 
try using field ids instead (although this has probably no influence on 
performance).


Regards,
Thilo


Deepak Parasam wrote:
> My intention of using ARS perl was to query remedy to get tickets status
> (updates), in near real-time.
> 
> Here's a snippet:
> 
> use ARS;
> ...
> $f = $c -> openForm ('HPD:HelpDesk');
> 
> @e = $f -> query (-query => "'Category' = \"AWS\" AND 'Type' = \"Subway
> 2.0\" AND 'Item' = \"Operations\" AND 'Case ID+'=\"0003044848\"");
> print "Iterating...\n";
> foreach (@e){
>         @arr = $f -> get (-entry => $_, -fields => [1, 8]);
>         foreach $field  (@arr){
>                 print "Field: " . $field . "\n";
>         }
> }
> 
> --- Though this works, it takes about 15 minutes (on an average) to
> complete execution.  Bulk of this time goes in opening the form.  
> When I ran strace, I could see that there were lots of poll calls,
> reads, and writes to the remedy server (remedy-1).
> 
> Any ideas to improve the performance ?!
> 
> - cheers,
>   Deepak
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>