Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement