[V4RB2] Speed or not speed ?

[Thierry Nauze]

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
......

(1) :  version V4RB1   :  0,40 s
 The database is endoding macRoman
 -  deCode for translation macRoman to UTF8
 -  enCode for translation UTF8 to macRoman and to escape the ' and the "


(2):  version V4RB2  :  76 s
The database is UTF16 and the translation is automatic
 - echappe only to escape the ' and the "

Where is the problem ?

Regards, 
-- 
Thierry Nauze               Saint-Denis de la Réunion