Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grid with Array
Message
 
 
À
27/02/2002 22:05:02
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00625553
Message ID:
00626207
Vues:
12
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform