>When I use macro substitution in queries on larger tables it is considerably slower than ruuning the query with the values instead.
>Does anybody have any ideas on this ?

Depending on where you've used macro-substitution, the macreo may have to be expanded for each record, rather than just once in executing the conversion from the embedded code to a literal. Can you post an example of where this is a problem?