General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>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.
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