Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Object Pooling and VFP as the datastore
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00430675
Message ID:
00431289
Views:
12
You can't leave dbfs open between page instances when using VFP COM objects so I don't think this is a real big issue.

+++ Rick ---

>In addition, if you are going to use direct access to VFP tables, you may find speed issues with opening and closing tables on every call. If you leave the tables open, make sure the COM server is on the same machine as the data since Windows only allows about 2000 file handles open across the network. If you have 20 file handles per instance (you probably will use more), you can only support 100 instances and then you'll get a nasty crash and will eventually find that an obscure message was written to the event log in NT.
+++ Rick ---

West Wind Technologies
Maui, Hawaii

west-wind.com/
West Wind Message Board
Rick's Web Log
Markdown Monster
---
Making waves on the Web

Where do you want to surf today?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform