I would look at the table or view that the report is based on and make sure you have indexes set up correctly.
At 09:30 AM 4/15/2005, you wrote:
I am in the process of setting up a small peer to peer network. The size of the database is approx 620 meg. The database has one report that will take 5 min to run on a standalone operation. However, when I run the same report across the network, it will take 35 minutes. This is running the report from a workstation. If I run the same report on the host PC, the time will drop to 5 minutes again.
I have the Scratch setting ON and the QualCol is set to 10. If I copy the database across the network, it takes about 3 minutes. I have RBASE installed on both machines and the directory on which it resides is shared. The workstation has an icon on the desktop that accesses the database on the shared folder.
What should I be looking for to help improve the speed of the report runnig from the workstationt. BTW I have very little exprerience on networking. The program upto this time has been standalone, howerver, our growth is dictating that the program become accessible to all(currently 5 people).
Thanks,
Dan
Dan Champion Information Services Service Coordinator Vredevoogd Heating 3047 Sangra SW Grandville, MI 49504 (616) 534-8271 x10 www.vredevoogd.com www.championsolutions.net
