comparing RunRev SQL method with Valentina method

[Ruslan Zasukhin]

On 7/5/08 3:53 PM, "william humphrey" <shoreagent at gmail.com> wrote:

> When I do this (for 5000 records):
> 
> It takes minutes:
> 
>   put "select trim(i_clients_companyname || ' ' || i_clients_Lastname || ',
> ' || i_clients_firstname || ' ' || i_clients_middlename) as clients,
> i_clients_id, RecID from info_clients" & SQLWhere into tSQL
> 
>   put revDataFromQuery(tab,return , sDatabaseId,tSQL)into tVar
> 
> 
> 
> But when I do this:
> 
> It is very useable and takes less than a second.
> 
> 
> put "select trim(i_clients_companyname || ' ' || i_clients_Lastname || ', '
> || i_clients_firstname || ' ' || i_clients_middlename) as clients,
> i_clients_id, RecID from info_clients" & SQLWhere into tSQL
> 
> 
> 
> 
> 
>   put VDatabase_SqlSelect( mDatabase, tSQL ) into CursorRef
> 
> 
>   put VCursor_GetRecords(cursorRef,1,recCount,tab,return ) into tVar
> 
> 
> 
>   set uData of fld "theData" to tVar
> 
> 
> -- Am I doing something wrong when I do the RunRev SQL method? I must be
> because also the RunRev method is only returning one record in the output.

Both ways do the same task as I see, right ?
They extract all records of cursor into STRING variable, right?

Hmm, 

Then only I can say that our code is faster of code that Revolution guys
have write :-)


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