>>>>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.
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