[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
> ......
> 
> (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 ?

Send to me this project please.

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