[V4RB2] Speed or not speed ?

[Ruslan Zasukhin]

On 4/1/05 1:46 PM, "Thierry Nauze" <ohmitou at wanadoo.fr> wrote:

> Hello,
> 
> For the above  loop  : version V4RB1 :  0,4 s  and  version V4RB2  76 s !
> 
> With the same program (adapted), the "same" base (created and filled with
> my same way)...
> 
> ......
> res=curseur.firstRecord
> for i=1 to nbFiches
> (1) nom=deCode(curseur.field(1).getString)
> (1) kurseur=zeBase.SQLselect("SELECT id FROM individus WHERE
> nom='"+enCode(nom)+"' AND ("+critere+")",kvServeur,kvNoLocks)
> (2) nom=curseur.field(1).getString
> (2) kurseur=zeBase.SQLSelect("SELECT id FROM individus WHERE
> nom='"+echappe(nom)+"' AND ("+critere+")", EVCursorLocation.kServerSide,
>  EVLockType.kNoLocks)
>         if kurseur<> nil then
>             listeNoms.addFolder nom+" : "+str(kurseur.recordCount)
>         end
>       res=curseur.nextRecord
>  next
> ......

* How many iterations in this loop?

* Have you set search fields to be index ?

    v2 will NOT index field on search and will do NON-indexed search.

* have you disabled V4RB_LOG file ?


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]