Show Commands are Slowing Speed of Filepro
Nancy Palmquist
nlp at vss3.com
Wed Jan 11 10:44:37 PST 2006
Mike Fedkiw wrote:
> computer: p4 2.4 GHz dual processor
> operating sys: win2000 advanced server
>
>
> I recently tried upgrading from 5.0.09 to 5.0.14. After installing the
> upgrade I noticed some of my programs go quite a bit slower. Where I
> notice it the most is where I draw a screen with a header and footer,
> then put a browse window between them. I use quite a few show command to
> overwrite the top and bottom lines of the browse with a different color
> and some graphic characters to make the browse window look more like
> part of the screen. I know the simple solution is not to do the show
> commands but the older version 5.0.09 went about 3-4 times faster when
> scrolling through the browse with the show commands. Something must have
> been changed between these two versions, (probably for fpgui?). Is there
> anyway to get the speed back with the newer version?
>
> P.S. the gosub for the show commands is in the processing for the browse.
>
> Thanks You in Advance
> Mike Fedko
>
>
>
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
Mike,
Did you rebuild indexes after the upgrade?
Check the size of the dclerk in the old and new versions, did they
change by any large degree? This could be a memory issue where the
program and the data are just bigger than the available RAM and so they
are swapping to the hard drive. This can manifest as a much slower result.
Network issues - You did not mention if the program or data are on a
network drive and are being dragged across your network. If so, try the
program directly on the server and if the speed is much faster, the
network is what is slowing you down. You can install the programs on
the client and just get the data across the network. That will decrease
the network traffic and improve some speed issues.
Just a few ideas for things to check.
Nancy
--
Nancy Palmquist MOS & filePro Training Available
Virtual Software Systems Web Based Training and Consulting
PHONE: (412) 835-9417 Web site: http://www.vss3.com
More information about the Filepro-list
mailing list