General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only