vfp9 speed issue

group,
our app has several screens with hundreds of objects. They open
instantaneously in vfp6 but they take over 10 seconds in vfp9, making 9
totally useless for us. Has anyone come across this type of behavior? We use
vfp9sp1.
Wade

Man-wai
Sun Mar 25 21:18:53 CDT 2007

W.Davis wrote:
> group,
> our app has several screens with hundreds of objects. They open
> instantaneously in vfp6 but they take over 10 seconds in vfp9, making 9
> totally useless for us. Has anyone come across this type of behavior? We use
> vfp9sp1.

Did you use form.lockscreen to batch update the screen?

--
iTech Consulting Services Limited
Expert of ePOS solutions
Website: http://www.itech.com.hk (IE only)
Tel: (852)2325 3883 Fax: (852)2325 8288

Fred
Sun Mar 25 21:43:49 CDT 2007

Is it the screen's objects or the differences in VFP9's handling of the data
tables being opened/positioned?

--
Fred
Microsoft Visual FoxPro MVP


"W.Davis" <wdavis3@cinci.rr.comNOSPAM> wrote in message
news:uA7AY5xbHHA.264@TK2MSFTNGP05.phx.gbl...
> group,
> our app has several screens with hundreds of objects. They open
> instantaneously in vfp6 but they take over 10 seconds in vfp9, making 9
> totally useless for us. Has anyone come across this type of behavior? We
> use vfp9sp1.
> Wade
>

W
Mon Mar 26 08:55:10 CDT 2007

yes, but that has nothing to do with speed. 10 seconds vs. instantly is a
major speed problem with vfp9. Makes it unusable.

"Man-wai Chang" <toylet.toylet@gmail.com> wrote in message
news:#r$fe00bHHA.2088@TK2MSFTNGP05.phx.gbl...
> W.Davis wrote:
> > group,
> > our app has several screens with hundreds of objects. They open
> > instantaneously in vfp6 but they take over 10 seconds in vfp9, making 9
> > totally useless for us. Has anyone come across this type of behavior? We
use
> > vfp9sp1.
>
> Did you use form.lockscreen to batch update the screen?
>
> --
> iTech Consulting Services Limited
> Expert of ePOS solutions
> Website: http://www.itech.com.hk (IE only)
> Tel: (852)2325 3883 Fax: (852)2325 8288

W
Mon Mar 26 08:56:56 CDT 2007

The tables are all opened previously. What could be different in the
handling of the data from 6 to 9? Screens with just a few objects open ok.

"Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
news:ukTzWC1bHHA.4720@TK2MSFTNGP04.phx.gbl...
> Is it the screen's objects or the differences in VFP9's handling of the
data
> tables being opened/positioned?
>
> --
> Fred
> Microsoft Visual FoxPro MVP
>
>
> "W.Davis" <wdavis3@cinci.rr.comNOSPAM> wrote in message
> news:uA7AY5xbHHA.264@TK2MSFTNGP05.phx.gbl...
> > group,
> > our app has several screens with hundreds of objects. They open
> > instantaneously in vfp6 but they take over 10 seconds in vfp9, making 9
> > totally useless for us. Has anyone come across this type of behavior? We
> > use vfp9sp1.
> > Wade
> >
>
>

Man-wai
Mon Mar 26 09:08:40 CDT 2007

> yes, but that has nothing to do with speed. 10 seconds vs. instantly is a
> major speed problem with vfp9. Makes it unusable.

How about attaching the form.sc* here (if the codes have no sensitive
stuffs)?

--
.~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Ubuntu 6.10) Linux 2.6.20.4
^ ^ 22:07:01 up 2 days 9:19 0 users load average: 1.04 1.01 1.00
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk

Dan
Mon Mar 26 10:12:10 CDT 2007

I had to make sure all the code pages in my tables matched my OS in order to
get good performance when I upgraded to VFP9.

http://fox.wikis.com/wc.dll?Wiki~VFP9RushmoreAndCodepage~VFP


"W. Davis" <foxteeth@zoomtown.com> wrote in message
news:ervDgZ6bHHA.2316@TK2MSFTNGP04.phx.gbl...
> The tables are all opened previously. What could be different in the
> handling of the data from 6 to 9? Screens with just a few objects open ok.
>
> "Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
> news:ukTzWC1bHHA.4720@TK2MSFTNGP04.phx.gbl...
>> Is it the screen's objects or the differences in VFP9's handling of the
> data
>> tables being opened/positioned?
>>
>> --
>> Fred
>> Microsoft Visual FoxPro MVP
>>
>>
>> "W.Davis" <wdavis3@cinci.rr.comNOSPAM> wrote in message
>> news:uA7AY5xbHHA.264@TK2MSFTNGP05.phx.gbl...
>> > group,
>> > our app has several screens with hundreds of objects. They open
>> > instantaneously in vfp6 but they take over 10 seconds in vfp9, making 9
>> > totally useless for us. Has anyone come across this type of behavior?
>> > We
>> > use vfp9sp1.
>> > Wade
>> >
>>
>>
>
>

Fred
Mon Mar 26 10:16:16 CDT 2007

If you're trying to position the tables via SEEK or you're doing SQL SELECTs
against the tables and you have indexes that have STR() in them, there is a
bug in VFP9 in that case. There may be other issues that could slow it down
too. In most cases, VFP9 is way faster in object handling than VFP6, but
there are some data access issues.

--
Fred
Microsoft Visual FoxPro MVP


"W. Davis" <foxteeth@zoomtown.com> wrote in message
news:ervDgZ6bHHA.2316@TK2MSFTNGP04.phx.gbl...
> The tables are all opened previously. What could be different in the
> handling of the data from 6 to 9? Screens with just a few objects open ok.
>
> "Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
> news:ukTzWC1bHHA.4720@TK2MSFTNGP04.phx.gbl...
>> Is it the screen's objects or the differences in VFP9's handling of the
> data
>> tables being opened/positioned?
>>
>> --
>> Fred
>> Microsoft Visual FoxPro MVP
>>
>>
>> "W.Davis" <wdavis3@cinci.rr.comNOSPAM> wrote in message
>> news:uA7AY5xbHHA.264@TK2MSFTNGP05.phx.gbl...
>> > group,
>> > our app has several screens with hundreds of objects. They open
>> > instantaneously in vfp6 but they take over 10 seconds in vfp9, making 9
>> > totally useless for us. Has anyone come across this type of behavior?
>> > We
>> > use vfp9sp1.
>> > Wade
>> >
>>
>>
>
>

KevClark64
Mon Mar 26 10:42:40 CDT 2007

Have you stepped through the code line by line to see what is taking
so long? Alternatively, use the code profiler, which will give you
pretty exact times on how long each line is taking to run. Someone
mentioned SELECT statements in a reply. There are some SELECT's that
are instantaneous in Fox 6 but take a long time in Fox 8 or 9. You
can rewrite your queries or modify indexes to get around the problem.

Kevin Clark
Seton Home Study School

W
Wed Mar 28 20:14:59 CDT 2007

Set Enginebehavior 70 fixed the speed slowdown.... looks like I have some
rewriting to do. Thanks for the great replies.... I'll be looking for those
'gotchas'

"W.Davis" <wdavis3@cinci.rr.comNOSPAM> wrote in message
news:uA7AY5xbHHA.264@TK2MSFTNGP05.phx.gbl...
> group,
> our app has several screens with hundreds of objects. They open
> instantaneously in vfp6 but they take over 10 seconds in vfp9, making 9
> totally useless for us. Has anyone come across this type of behavior? We
> use vfp9sp1.
> Wade
>

Fred
Wed Mar 28 20:44:05 CDT 2007

Then you either have a code page or index issue. SET ENGINEBEHAVIOR is SQL
related, so it almost has to be one of those issues.

--
Fred
Microsoft Visual FoxPro MVP


"W.Davis" <wdavis3@cinci.rr.comNOSPAM> wrote in message
news:e%23F6s%23ZcHHA.2120@TK2MSFTNGP03.phx.gbl...
> Set Enginebehavior 70 fixed the speed slowdown.... looks like I have some
> rewriting to do. Thanks for the great replies.... I'll be looking for
> those 'gotchas'
>
> "W.Davis" <wdavis3@cinci.rr.comNOSPAM> wrote in message
> news:uA7AY5xbHHA.264@TK2MSFTNGP05.phx.gbl...
>> group,
>> our app has several screens with hundreds of objects. They open
>> instantaneously in vfp6 but they take over 10 seconds in vfp9, making 9
>> totally useless for us. Has anyone come across this type of behavior? We
>> use vfp9sp1.
>> Wade
>>
>
>

imaginecorp
Tue Mar 27 22:18:10 CDT 2007

10 Seconds is too long irrespective of the objects on the forms.
having said that:
Yes there is a little excess bagage in VFP9, but nothing to make it slower
than VFP6.
Actually I have found the reverse.

When you run the Very Same App (.EXE) in VFP6, No code changes, it runs
instantaneously? The application, not the exe, may feel slow in design mode,
but will be fast in .exe. Have you tested the .exe?
--
Mohammed Ashruff
www.imaginecorp.com


"W.Davis" <wdavis3@cinci.rr.comNOSPAM> wrote in message
news:uA7AY5xbHHA.264@TK2MSFTNGP05.phx.gbl...
> group,
> our app has several screens with hundreds of objects. They open
> instantaneously in vfp6 but they take over 10 seconds in vfp9, making 9
> totally useless for us. Has anyone come across this type of behavior? We
> use vfp9sp1.
> Wade
>