>>>>Hi all,
>>>>
>>>>I'm thinking to use the above to run a table-driven SQL Select which is stored in a memo field. For those who has done this b4, it is advisable in the sense of deterioting speed? Thanks in advance...
>>>
>>>It'll be slower than macro substitution because EXECScript has to do following steps
>>>- Write code, passed as parameter, to a temporary file on disk
>>>- Compile it
>>>- Run it
>>
>>Thanks Sergey for the reply. I understand it will be slower but is it bearable? I have tried doing on a small data set and it seems to be OK. Has anyone really used this route for huge data set?
>>
>>
>Farouk,
>
>You missunderstood me. EXECScript has no affect on query performance but adds some overhead in preparing it to run as I described above.
Hi Sergey,
Oops, sorry. OK I understand now. Thanks again.
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