Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating Views on the fly
Message
 
 
To
25/07/2000 21:17:03
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00396744
Message ID:
00397019
Views:
11
>>>> 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
Previous
Reply
Map
View

Click here to load this message in the networking platform