[Arsperl-users] Performance problems
Brought to you by:
jeffmurphy
|
From: Paizo <pai...@gm...> - 2007-08-02 10:50:52
|
Hi Listeners,
I have some performance problem executing a perl script working like below:
$var1 =3D "something1";
($x1 =3D ars_GetFieldByName($ctrl, $ARSschema, $var1)) || die "bla bla
bla.\n";
...
$varn =3D "somethingn";
($xn =3D ars_GetFieldByName($ctrl, $ARSschema, $var1)) || die "bla bla
bla.\n";
#####i used ars_GetFieldByName because ars_GetFieldTable didn't work always
( i don't know why )
#######then i load the qualifier:
($qual =3D ars_LoadQualifier($ctrl, $ARSschema, $str_qual)) ||
die "ars_LoadQualifier: $ars_errstr";
...
####i retrieve the results ( don't take too much time ):
(%entries =3D ars_GetListEntry($ctrl, $ARSschema, $qual, 0, 0)) || die
"ars_GetListEntry: $ars_errstr";
#### then i cicle for save the data in a file ( that is the bottle neck ):
foreach $entry_id (sort keys %entries) {
$something1 =3D ars_GetEntry($ctrl, $ARSschema, $entry_id,$x1);
...
$somethingn =3D ars_GetEntry($ctrl, $ARSschema, $entry_id,$xn);
print datafile "$something1|$something2|...|$somethingn\n";
}
That's take up too 1 hour for finish while using the same qualification wit=
h
AR System User take less than 2 minuts....
How can i speed up that code?
Thanks,
Paizo
--=20
--------------------
A me cugin na volta xe nd=E0 dal geataro e el ga domand=E0 na coppetta trig=
usto
co i gusti seegheta, sarexe e schie co na fettina de poenta.
El geataro pena sentio che=E0 goduriosa scelta, el se ga messo subito el
pigiama de banane e el ghe ga messo in testa a corona de poegge medie e lo
ga fatto diventare Re dei Gelati Biricchini.
-----------------------
Confezione trigusto seegheta/sarexe/chie co pratico contenitore par e fete
de poenta, stile estat=E8 o quea dea ciocoeata
Altri gusti poe essere bigadini/kiwi/lasonil co socoi de vacca da tociare o
erbagatta/straciatella/calsina co coe de sorxe da tociare
------------
Rileggendo a firma diria che se poe puntare al mercato dei ghiaccioli col e=
l
gusto crema al diserbo e parafl=F9 ricoperta da una soffice crosta de pus c=
o
al posto del bacheto un termometro anale pratico pa misurarse a freve dopo
aver magn=E0 el geato (chi xe che no lo fa al giorno d'oggi?!?!). Garantite
scorese bitonali e solfeggi anali.
|