Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is the best database for searching
Message
 
To
16/05/2002 03:01:00
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00657277
Message ID:
00657335
Views:
13
Rajesh:

If performance is a concern, then you need to consider how much bandwith you have. VFP works well on a good LAN, but will be painfully slow over a WAN because it's a file server database. To process a query, it has have to drag a lot of information over the netowrk to the client.

If your on a WAN, then you need something that will process queries in the server's memory space and return only the result set. You can either purchase SQL Server or you can accomplish the same thing by using a VFP COM object on server to process query and return an XML result set.

Charlie
Previous
Reply
Map
View

Click here to load this message in the networking platform