Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid with Array
Message
From
28/02/2002 03:24:20
 
 
To
27/02/2002 22:05:02
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00625553
Message ID:
00626207
Views:
16
Hi!

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.

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.

>Hi Vlad,
>
>>What you mean as "fetching" the data?
>
>I mean that I fetch information from some table and put it into a cursor.
>
>>Really, there is a way to put data into array and display them in the grid. However, the approach is slower than displaying data directly from the table in the grid. The slow things might come from bad indexes or from use of filters. Grid works very slow with filters. When you want to display a subsets of data for users, better use views or SELECT SQL statement to query the subset of data and display it for users. IN such case you wll have no any SET FILTER on your data, and grid will work very quickly.
>
>I didn't use Filters and I think my index is good but I didn't use views or select SQL, I ever used a cursor with select SQL but the result is the same with using cursor with usual commands like (I.e : repl ..., appe blank).
>I tried it in my computer not in the user's computer, maybe because I opened many app. that makes the program slow.
>
>
>TIA,
>
>Budianto
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.com
ICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs

It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform