Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FOXPRO vs ORACLE
Message
From
13/05/1999 04:26:52
Vladimir Zhuravlev
Institute of the Physics of Earth,Russia
Moscow Region, Russia
 
 
To
12/05/1999 03:24:03
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00217195
Message ID:
00218271
Views:
32
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform