System drastically slows down! 2

[gogins]

Dear All,

VFP6, 12 users, max records 60K, plenty of spcae on disc,
plenty of memory on server, 40x.scx, 20x.dbf

The system above has been running beautifully for 8 months or so until two weeks ago, when operators began to complain about a slowing response time.

When the users start anew in the morning, response is ok but then quickly slows down (when painting the main form) from 2 secondes to 70 secods and worse.

80% or more of the time taken to paint the said main form is taken up by the re-building of the 14 columns grid on that form eg: assigning recordsource, columns controlsources, widths etc and refresh.

I would really (of course) appreciate any suggestions which might help explain the above behaviour.

 

[mkrausnick]

I would check the indices of the tables referenced in the grid. Maybe an index got dropped and Rushmore optimization doesn't kick in.

Next I'd check all views and relations open anywhere in the form or the form's caller for the same thing - a missing tag will kill you. Make sure all views and relations reference fields that are indexed.

Mike Krausnick
Dublin, California

 

[torturedmind]

i'd say i agree with sir mike. i also suggest to PACK all DBF's for better record accessing.

sure hope this help. peace!

kilroy
philippines

"Illegitimis non carborundum!"

 

[jimoo]

Is the app ran from the network? The network is usually the biggest bottle-neck. Yes, I know the network gurus don't like to hear that, but it is true.

See if the installed or upgraded to a new client or if there is a new process running at this time. Maybe they rescheduled backups or SQL data pulls?

Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com

 

[foxwizard]

I have an application developed last 1999 and still working properly today with almost a million records on some production tables, hundreds of thousands of records on some reference tables, and at least 50 users connected. We these volumes we haven't experienced any slow down as far as speed and performance are concerned. As if the tables are zero records. Perhaps you could give us some specific details about the programs and its setup so that we can have a clear picture of the problems.


Bren
Project Team Head
Philippines

 

[craigsboyd]

Given that the application has been running like a champ for 8 months and now it is dog slow with no apparent changes to the app nor any appreciable difference in data size, and the fact that all the users are starting to complain about this and you mention a server...I'm gonna guess that the app is running over a network of some kind in some fashion and that the problem is related to either the server or the network itself...the only other thing I can think of that it could be given the symptoms as you have laid them out is the very slim chance that all of these workstations had some kind of hardware or software change that was done at nearly the same time that is not compatible with your app. I would go to the IT people and ask them about any changes that were made right around the time when the performance degradation was first noticed...changes to the server, the network, or to all of the workstations that appear to be affected. If you ARE the IT guy then I would ask myself the same kinds of questions and if I drew a blank I would run some diagnostic tests, fresh installs, and try some configuration changes. If you find that the problem is related to a new employee who likes to listen to internet radio all day and download MP3's by the hundreds using Kazaa then just shoot him, you'll be doing more than just your application a favor.

_{craig1442@mchsi.com}

"Whom computers would destroy, they must first drive mad." - Anon​

 

[MarvinR]

V I R U S ?

 

[GriffMG]

All the above advice is good - except the shooting that Craig suggests (it's too good for users like that!).

My pennyworth suggests checking the anti-virus s/w on the clients and server. Some of the latest versions of Norton and McAfee have had (anecdotally) compaints that they are over aggressive.

Secondly, could you be running into the Op' Locking problem?
Have you added or upgraded a wokstation lately?
Have you applied a service pack to one or more machines - apparently IBM are instructing staff NOT to apply the latest MS SP for XP, due to 'known conflicts with mission critical and customer specific applications'.

Regards

Griff
Keep [Smile]ing