Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Huge DBC
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00409138
Message ID:
00409619
Views:
25
>The application creates and drops about 700 remote views each time it is run - which probably explians how it grew to this size. Thankyou very much for your help.

Continuously adding and dropping views from a multi-user DBC [your master DBC for the app] is a very bad idea. I can not stress that point enough. If you just have to create RVs on the fly, create a temp DBC to create your remote views in. Then delete the DBC, DCT and DCX on app shutdown.

IMO, not knowing the full extent of your app, probably the best solution is ADO or SPT.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform