General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
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