Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Visual foxpro and Visual Basic .. which is the best?
Message
 
 
À
23/07/2000 20:26:27
Teddy Win
Bytel Information Technology
Jakarta, Indonésie
Information générale
Forum:
Visual Basic
Catégorie:
Autre
Divers
Thread ID:
00395861
Message ID:
00396041
Vues:
12
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform