Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
FOXPRO vs ORACLE
Message
De
13/05/1999 04:26:52
Vladimir Zhuravlev
Institute of the Physics of Earth,Russia
Moscow Region, Russie
 
 
À
12/05/1999 03:24:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00217195
Message ID:
00218271
Vues:
33
It is bad habit to argue. But I like to share my expirience.
I this there is the difference between MS SQL and Oracle from VFP programming.
I tested speed of the work from VFP to Oracle 7 and MS SQL 7.
Second is much slower.
Calling Oracle procedure with select inside from VFP does not produce any cursors in VFP, calling MS SQL procedure with select will produce the cursor.
There is different mechanism how to assign the primary key for MS SQL and Oracle
MS SQL has identity , wich inserted like default value of the primary key, so key value became known after insert into table like @@identity.
In Oracle there is the sequence object to generate keys values, but it can not be used in default for field. So program should call identity and use it in insert command, so key value is known before the insert. I counted near 50 differencies between Oracle and MS sql, which makes the limitation on scalebale
program in VFP wich will work in simmetrical way for these products.
I am personnaly have not any preferance between these servers, my user commands me, if he will pay for Oracle, I make Oracle, if he desided to take MS SQL, it is OK for me, I am outside of war between companies to promote their servers.
MVP-2006-2011, PHD in Math and Physics ,
host of www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform