If you mean the query template is returning a large number of records, then it is probably not very efficiently scoped for your application. If you mean it is a very large script with many different subsegments, then I would recommend creating a Stored Procedure, View, or User Function in the database and simply execute that database object. Databases are more efficient in almost all cases with manipulating datasets especially as they grow in size.
Can you provide more details on the issue that confronts you?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.