Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>>>I think someone told me to avoid macro, so i asked the alternate ?
>>To validate and for a speed comparison, create the three SQL expressions...
>I agree and I think for that particular case since macro is evaluated only once,
>there will be very small performance gain which may be not visible.
Of course.
My reply was more to teach that it's sometimes very easy for a person to test any possible performance issues, rather than sticking to a hard-and-fast rule. In this case Mk Sharma would find there is no measurable difference, even on hundreds of thousands of iterations. And, in general, the code design is very clean with the simple DO CASE above and SQL expression visible on the same page below.
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