Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Sql tables with views for dummies
Hi All,
The whole concept of views for SQL database is new for me. I have read a lot about but still have a problem with it.
I am converting a network application, which worked nicely in the past with VFP database and tables to SQL tables with views. I have a transaction table of 1 million records (29 fields).
The problem is that any time I open a form and the view is in the data environment, it does the whole SQL select again. This takes very long time (about 2 minutes) and no one can wait so long just to open a form.
I have tried to load with no data, which is naturally fast, but it's not really helping as I need to view previous data when data is entered in the form (balances etc.). Furthermore, when the user has saved his entry, and stays in the same form, the data is not updated. i.e the view saves the data to the original SQL tables, but it does not update itself with other users' new transactions. I am using local views. Should I use remote views?
In a nutshell: How is possible to work with a view the same way I used to work with a table, so that it will updated all times.
I am a bit lost here. Could you share some experience with me?
Thanks in advance
Jonathan
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