Sherrie, What are/is the index expression and what is the actual SQL syntax you are using?
Also have you got "Set Tablevalidate 0" to remove the header checking in VFP9 which is NOT a default setting Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sherrie Binder Sent: 18 September 2007 16:41 To: [email protected] Subject: VFPRO 7 -> VFPRO 9... SELECT is now slow 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. [excessive quoting removed by server] _______________________________________________ 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.
