I would never use VFP on a WAN. Only low traffic LAN's and single user applications.
When I said 'Poor Man’s SQL Server' I meant a VFP COM server requesting data from a VFP database on the same machine is acting like a SQL database because its running queries in a separate process from the client. Now, since the data is local to the COM server, I assumed it would be very fast as VFP has an excellent reputation for speed. I backed this up with the testing Rick Strahl published in his book. He was probably using SQL Server 6.5, if that makes a difference.
So, just for grins, I opened a VFP table in the VIEW window and issued select * in the command window and the results came back instantaneously. I did the same thing in the Query Analyzer and it took noticeably longer, but it was still very fast. If this is not a fair comparison, then I stand corrected and I'm the biggest turkey in the world.
Regards,
Charlie
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only