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
> Arsperl-users@arsperl.org
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>
-------------------------------------------------------------------------
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
Arsperl-users@arsperl.org
https://lists.sourceforge.net/lists/listinfo/arsperl-users
