Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Vlad,
>Grids might become slow also in case you have a lot of code on the form related with grid. Specially if you used DYnamic* properties of grid columns.
Here is the code when I put it into Grid :
sele maintable
seek varname
Do While varname=fieldname .and. !eof()
Sele table1
seek varname
If Found()
put information to varname
EndIf
Sele table2
seek varname
If Found()
put information to varname
EndIf
Sele table3
seek varname
If Found()
put information to varname
EndIf
If condition=.t.
sele tmpfile
appe blank
repl 12 field to varname
EndIf
Sele maintable
Skip
EndDo
What is DYnamic* properties ?
>I have application constantly running and taking 98% of processor resources, as well as up to 10 applications opened, but grids in my VFP applications are flying like a rockets. That is why it is wondering for me.
>
I process the records (about 40,000) and if flys around 10 sec and I compare with Clipper program which flys around 1 sec (in Clipper use Array), even when the network is busy The visual Foxpro took 20 sec, while in Clipper took 5 sec.
This happened in my computer with 5 application opened.
If you don't mind could you give me an example grids code of your VFP application that flys like a rockets ?
TIA,
budianto
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement