Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Visual foxpro and Visual Basic .. which is the best?
Message
 
 
To
23/07/2000 20:26:27
Teddy Win
Bytel Information Technology
Jakarta, Indonesia
General information
Forum:
Visual Basic
Category:
Other
Miscellaneous
Thread ID:
00395861
Message ID:
00396041
Views:
11
>Thanks for your answer, but how about the speed, time record accessing?
>
>Regards
>Teddy

If you are talking about any kind of data access, it depends on the back end. If you are using Access then VB is going to be the fastest as it can use Access directly. If you are using SQL Server then it's a toss up because both have to go through an outside source (OLE-DB or ODBC). If you want the fastest then you should use a VFP front end with a VFP back end.

VFP's data engine is very fast. It utilizes a technology called Rushmore to optimize its queries. Rushmore was integrated into the Jet and SQL Server data engines but VFP is still the king in this regard.

VFP can be used for any size application where I've heard Access starts to bog down at 10 to 15 simultaneous users and you have to scale up to SQL Server. VFP doesn't have this performance problem.

VFP does have one major limitation and that is database security. It has none. People can access the tables freely as long as they have a copy of VFP. Version 7 will have hooks to help alleviate this hole, but it still exists. If security is a major concern, then I would recommend SQL Server as the back end with VFP or VB as the front.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform