Re: Check box checking & application loads slow
From: Lee Mitchell (Leemi_at_online.microsoft.com)
Date: 08/30/04
- Next message: Ch Löfberg: "Decide a built cursors Database programatically - VFP8"
- Previous message: Demetrios Panayiotakopoulos: "Re: what is this?"
- In reply to: Gar: "Re: Check box checking & application loads slow"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 30 Aug 2004 14:13:39 GMT
Hi Gar:
Regarding the performance problem at the client's site, I would like to add
a few comments. Make sure VFP's internal usage of memory is optimized with
the SYS(3050) function. Make sure the VFP temp files are directed to a
local and not a network drive. Use the SYS(2023) for this task. Finally,
optimize any SELECT-SQL commands you use with the SYS(3054) function.
176483 PRB: Large Amounts of RAM Seem to Process Data Slowly
http://support.microsoft.com/?id=176483
248608 INFO: SQL SELECT Optimization Levels and Performance
http://support.microsoft.com/?id=248608
156551 How To Use SYS(3054) to Optimize a Query
http://support.microsoft.com/?id=156551
I hope this helps.
This posting is provided "AS IS" with no warranties, and confers no rights.
Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell
*-- VFP9 Public Beta Now Available!! --*
Download the VFP9 beta here: http://msdn.microsoft.com/vfoxpro/
*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518
Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003
>Thanks for the input Josh.
>I don't know what code to post yet because I'm having a very difficult
time
>replicating the check box problem. I will continue to try and you're
>probably right that I will find a solution. I hope so!
>As far as me saying "Well, it works on my dev box", I agree with you 100%
>and promise you I know that's no excuse nor will I lean towards that when
>explaining to them. I'll try a more detailed analysis on-site but won't
be
>there until this Thursday.
>Thanks again.
>"Josh Assing" wrote:
> >1) At some point when using the check boxes on a pageframe they don't
check
> Can you post some sample code to replicate it?
>
> Often times, trying to narrow it down to "show" it to others, you'll find
the
> solution.
>
> >2) When loading the app on one of the clients PCs it may take 30 seconds
or
> is it running anything off a network?
>
> >dev PC and doesn't happen all the time on that one client PC. I believe
it
> NEVER NEVER compare a client pc to yoru DEV machine.... they're not the
same.
>
> Get a machine dedicated for testing purposes. I have 5 test machines;
and I
> can ghost images to it for any os I want for testing purposes.
>
> Your dev machine has "dev" ocx's on it; different software & drivers --
all this
> gears you to failure if you say to a client: "Well, it works on my dev
box"
>
>
> Try using the coverage profiler. Sometimes filemon & regmon can show
some clues
> -- but that gets overwhelming sometimes.
>
> ---
> Remove x's to send.
>
- Next message: Ch Löfberg: "Decide a built cursors Database programatically - VFP8"
- Previous message: Demetrios Panayiotakopoulos: "Re: what is this?"
- In reply to: Gar: "Re: Check box checking & application loads slow"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
