speed

[Ruslan Zasukhin]

On 5/7/05 8:30 AM, "Jules Jacquot" <jules.jacquot at wanadoo.fr> wrote:

Hi Jules,

Asnwer is next:

* Listbox of REALBasic is not intended to show records of database.

    when you work with listbox you must read from db each field of cursor
    and each record.

* viSQL do more smart work I think. It ask only values which must be shown
right now. I.e. You can have 100 fields In cursor, but window can show only
5, so what sense read rest 95 fields ?

DataGrid of Einhugur also is able do this.

I have hear that Frank have made new version of listbox which is smart, and
Kem also work on such version of listbox.


> hi ruslan
> 
> classic question
> 
> i am using these code for to display 592 records on the listbox
> 
> inquery=mdatabase.SQLSelect("select * from usertable order by jnumeng")
> assigncursor(inquery)
> 
> the duration is 41 sec
> 
> now go through Visql
> 
> the duration is 0,01sec
> 
> adapt to my app with VIsql
> 
> the duration is 1,60 sec
> 
> why ? and how to do for to improve the speed ?


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