I just moved an application from VFP 7 to VFP 9. In a select command, I have only one table involved with a WHERE statement.
The WHERE statement includes a long expression which is exactly as it is in the index of the table. In VFPRO 7, the select takes .02 seconds. In VFPRO 9, the select takes 12.06 seconds. CPCURRENT() = 1252 CPDBF() = 1252 What am I missing? Thanks. Sherrie Binder Christian Record Services www.christianrecord.org *** Serving the Blind Since 1899 *** Confidentiality Notice: This message from Christian Record Services may contain confidential information. If you received it in error, please contact the sender by reply email and delete the message and any attachments. Sharing, printing, or using the contents is not allowed except by the intended recipient. Thank you. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** 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.
