Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating Views on the fly
Message
 
 
À
25/07/2000 21:17:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00396744
Message ID:
00397019
Vues:
10
>>>> Thanks in advance.
>>>Yes Creating the view on the fly should be faster
>
>I would test this first- creating a view on the fly and setting a bunch of view properties can take a while...
>
>>>Then, when you want to delete the view:
>>>USE IN Nadya
>>>DROP VIEW Nadya
>
>You should know that doing this repeatedly will results in a continually growing dbc file- Each time you create a new view and delete it, a record is added and deleted.

Thanks a lot, Erik.
I won't probably delete the view. I'll better keep it in the database and use in other applications.

If I have ~5000 records and I want to filter just 200 of them, I think, filter approach would be slower than view. I will test it today...
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform