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

[Michael A. <mic...@gm...>]

On 16/04/07, Deepak Parasam <dee...@am...> 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 ?!

Hi Deepak,

  just a shot from the hip -- but are the fields you base your query
on indexed (i.e. "Category", "Type" and "Item")? Does the same query
from within aruser the same time? Probably this is not a problem with
ARSperl at all...


-- 
Michael

"Microwave oven?  Whaddya mean, it's a microwave oven?  I've been
watching Channel 4 on the thing for two weeks."