faster loading

[earlrainer]

Hi,

The setup is like this..one server and 15 client computers.
we have a set of 10 programs and the database located on the server.
All the 15 clients access the programs on the server through a shortcut on their desktops.

The clients are complaining that the programs take a long time to load i.e the time interval between the moment they click the shortcut icon till the time the program is fully visible on their screen and ready to use is very high.

Can you suggest me some ways to fasten this loading.

The programs all connect to the database.we have also removed as much code as possible from the form create part. what else can be done?

will moving the programs to each client machine fasten the process?

Thanks for your time

 

[LucieLastic]

hi

Without knowing more about your system, it's difficult to advise you in detail. All I can suggest (initially) is to give the user some feedback, a splashscreen for example, to show something is happening. Then check whether all the stuff that is being loaded is actually needed as soon as the app is loaded. What exactly is it doing on the initial load? If queries are being executed, do these need optimising? Can you not show and unloaded form and then the user initiates the load? Need to know more about your system really.

 

[Griffyn]

If you do put in a splash screen, the way to do it properly is to first change all of your database components that are Active, so that they're not at design time. Then after the splash screen is displayed, change their Active properties to True one by one.

Usually, making programs load locally will be faster - but as LucieLastic said, it's hard to tell from here. Try testing this on one client, and then decide from there. But - if you do end up moving the programs to local folders, you may want to consider adding in an auto-update feature so you can simply dump new versions on the server, and have each program update itself automatically.