Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>>>hi,
>>>
>>>I always find Xbase commands faster than Sql(statement) commands.
>>>
>>>
>>>Any case where Sql statments are faster ?
>>>Also i would like to know best prsctices where to use what ??
>>>
>>>
>>>TIA
>>>suhashegde
>>
>>Post a example where XBASE is faster.
>
>I think, that indexseek/seek/KeyMatch is usually faster than Select-SQL.
sure for 1 to 100 indexseek/seek/KeyMatch vs 1 sql select,
but a query's 100% optimized over a dataset with 100 or more rows it must always win,
otherwise is an error of the VFPT
A great advantage of the SQL query is:
- if the VFP engine improves can improve a lot
- the time of execution is relatively high with little dataset,
but it improves with great amounts, therefore the time perceived from the customer is less variable.
A great disadvantage of the query is:
- the probability of having a bug in a sql engine is greater regarding that one of one simple XBASE command
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement