Stephen Russell said "I beg to differ. Each time you submit a query statement the server must create an execution plan for it. "
We've had this discussion before: according to my SQL Server book this is not true for v2000 and later - execution plans are cached and if a subsequent query differs only in the values in the where clause (~ 'parameters') the plan is re-used. Foxpro's sqlprepare() may also be relevant, but I don't know how it is handled by the bach-end. Andrew Davies MBCS CITP - AndyD 8-)# PC Development Officer Housing IT Housing Services Manchester City Council @Hawthorn Cottage ( Office +44 161 234 5330 ( Internal [814] 5330 ( Mobile 0775 938 5155 (when all else fails) * [EMAIL PROTECTED] * home [EMAIL PROTECTED] ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. Please contact [EMAIL PROTECTED] with any queries. ********************************************************************** _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.