speed

[Claudius Sailer]

Am 07. Mai 2005 um 11:48 Uhr schrieb Jules Jacquot:

> sorry
>
> to show 26 records and 11 fields in cursor ,
>
> viSQL set 0,01 sec and my app 1,6 sec
>
> same listboxs of RB 5.5.5

this seems to be extremely worse. I have 8 columns and 3000 rows from  
cursor to ListBox in RB 5.5.3 and it takes 0,5sec with V4RB1.x and  
2-3sec with V4RB2. Could you post some code? I believe this coding is  
not really optimized.

A really good thing is e.g.

   CurBuchungen=V4RBSQLSelect(meineDatenbank,SQLString)
   Ende=CurBuchungen.RecordCount

   //ListBox füllen
   L=ListBox1
   L.DeleteAllRows

   //Cursordefinitionen fuer Performance
   string1=CurBuchungen.StringField(2) //BDatum
   string2=CurBuchungen.StringField(3) //Gegenkonto
   string3=CurBuchungen.StringField(4) //Kategorie
   string4=CurBuchungen.StringField(7) // Kommentar
   Ein=CurBuchungen.LongField(6) //Einnahme
   Aus=CurBuchungen.LongField(5) //Ausgabe

   //ListBox fuellen
   For i=1 to Ende
     CurBuchungen.Position=i
     L.addrow string1.GetString
     NeueZeile=L.LastIndex
     L.cell(NeueZeile,1)=string2.GetString'ZielKonto
next

this speeds up. And I have 2 Listboxes. One of PagePanel 1 and second  
of OPagePanel 2. When I fill ListBox 1 I change to pagepanel where  
nothing is happen. This speed up too.


bye

Claudius

-- 
G4/733 QS / MacOS X 10.4de / RB 5.5.3de/ Valentina 1.10.0 & 2.0.3
Homepage    http://www.ClaSai.de
iChat        ryhoruk
RealBasic ListBoxes: [ I feel the need...the need for speed!!! ]