Database connection Speed issue

[BlakeB]

When watching the network monitor on the server we have our .tcw file on, it maxes out each time TCW opens.
We have a remote office with a dedicated fiber line that is limited to 10MB/s. Each time someone opens TCW it takes so long to connect to the file.

It seems as if the program queries for all of the data? If this is the case, is there a way to limit the query and make it smaller so it doesn't take so long on the first run? Which is when most people are trying to clock in. Then when the rest of the data is needed, for example when the user wants to look at their history, it does another query?

Please let me know.
Thanks

[Paul Mayer]

Yes the program has to get the data from all employees to display the "time cards" and the employees status, in or out. I just did some tests on out network to see the spikes and even with a database of 300 employees, the spike was less than a second to grab the data it needs.

Did you get our email about the beta test of the TimeClockServer? With remote offices, if you have your own web server, you can have them punch in and out with a web browser.