Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid with Array
Message
From
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:
00626152
Views:
13
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform