Good morning Yau;

Some thoughts:

With a 100T Network and a 20 meg file with n users, opening a table within 2 seconds sounds reasonable. In all likelihood as a table grows it will take more time to open. With even a few users doing things such as “end of the month close out”, things can be slow on even a well-designed system.

Having the exe on each client helps as well as having a fast machine.

One way to “speed up opening tables” is to open them, as the application is first instantiated. While the splash screen and other goodies are being presented is a good time to open tables. Users are less likely to notice a delay at that time and are “more forgiving”. The menu is built and the user is ready to select a form to open.

Another thought is to pull only the data which is needed through a view with No Data On Load set to .T.

I try to have all my forms open within 1.5 seconds. This seems to be the upper limit of most users as far as patience waiting for something to happen.

In reality my wife told me, “You will never be satisfied with the speed of any computer”! After being married for 37 years my wife knows me very well! I do not mind waiting for my wife but hate to wait for any computer! :)


Tom




>Hi all,
>I've a customer where they have about 40 clients (mostly win98) connected to a Win2k(SP3) domain server sharing out my app on VFP6SP5. Total database size around 200MB with the biggest table size around 20MB. Its using DHCP (No Wins) and TCPIP with Netbios enabled.
>The problem is that when I open the 20MB table from a client (Use tablename), it takes about 2 seconds for the task to be completed.
>Is there anyway to speed up the file opening process?
>Does it also mean that the process will take longer when the file grows?
>I wonder how performance (of opening a table) will be if the file size is say 1GB or 2GB.
>Thanks in advance.
>Yau