Re: Does JET process (slowly) the qdf.OpenRecordset statement?
From: Billy Yao [MSFT] (v-binyao_at_online.microsoft.com)
Date: 05/21/04
- Next message: CM: "repost - Fill Forms fields based on control value"
- Previous message: Jasmine: "Change text box color based on a value"
- In reply to: Sparky: "Re: Does JET process (slowly) the qdf.OpenRecordset statement?"
- Next in thread: Billy Yao [MSFT]: "Re: Does JET process (slowly) the qdf.OpenRecordset statement?"
- Reply: Billy Yao [MSFT]: "Re: Does JET process (slowly) the qdf.OpenRecordset statement?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 21 May 2004 17:48:35 GMT
Hi Sparky,
Have you run the SP in the Query Analyzer. If so, is there any performance issue?
Based on my experience, the issue seems to be an ODBC performance issue executing the pass-thru
query from MS Access. The issue can be caused by the Page Latches when perform the insertions. Please
read the following articles to exclude some known issues and apply the suggestions within the following KB
articles:
209091 ACC2000: How to Optimize Microsoft Access When Using ODBC Data Sources
http://support.microsoft.com/?id=209091
208858 ACC2000: Optimizing for Client/Server Performance
http://support.microsoft.com/?id=208858
If the verion of Jet engine 4.0 is earlier than 6.0, I recommend you apply the latest Jet 4.0 SP8 via:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;829558
to suppress the performance issue described in the KB 302496:
302496 ACC2000: Queries Are Slower After You Install Microsoft Jet 4.0 Service
http://support.microsoft.com/?id=302496
Please apply my suggestions above and let me know if this helps improve the performance. If there is any
headway from you, or should you have any questions and concerns on the , please feel free to post it in the
group.
Regards,
Billy Yao
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks!
- Next message: CM: "repost - Fill Forms fields based on control value"
- Previous message: Jasmine: "Change text box color based on a value"
- In reply to: Sparky: "Re: Does JET process (slowly) the qdf.OpenRecordset statement?"
- Next in thread: Billy Yao [MSFT]: "Re: Does JET process (slowly) the qdf.OpenRecordset statement?"
- Reply: Billy Yao [MSFT]: "Re: Does JET process (slowly) the qdf.OpenRecordset statement?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
