Walter Meester
HoogkarspelNetherlands
General information
Category:
Coding, syntax & commands
Hi plinio,
The xBase commands (SEEK, REPLACE, DELETE) etc are different than the SQL commands:
1. Since the xBase commands are record oriented, they are faster when handling the current record (DELETE, REPLACE). SEEK is always faster than SQL-SELECT to search for records.
2. xBase commands operate on buffered tables while SQL commands ignore buffered changes until they are commited.
3. SQL commands are set oriented, meaning that they are good at handling more than one record. The SQL - SELECT in particular is powerfull to do fast calculations with data. Personally I don't use SQL - DELETE or SQL - UPDATE a lot. They're a bit more limited compared with REPLACE and DELETE (Buffering changes, replacing in more than one table at once, Record vs Table locks etc.)
Personally, I think that with the xBase commands give you just a bit more control and performance in particular cases. SQL SELECT on the other hand gives you a very powerfull mechanism to query your tables fast and efficient (thus without doing a lot of xBase calculations).
I find that it depends on the given situation, for one xBase is far better, for others SQL is the clear winner.
Walter,
>Shoud I replace the use of : SEEK,REPLACE,DELETE and use SELECT * FROm where, Update WHERE, and DELETE FOR
>
>It's a good artinative??
>What's the diferences?? (speed,integrity???)
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