[RBG7-L] - Re: Small Network

[gary.wend]

Thanks all....   Bob thanks for the description on the how the Scratch setting works.  It really helps to understand exactly what is happening on the data.  Since there is great deal (14) of temp tables and views, cutting down the traffic across the network will really help. ----- Original Message ----- From: [EMAIL PROTECTED] To: RBG7-L Mailing List Sent: Friday, April 15, 2005 8:59 AM Subject: [RBG7-L] - Re: Small Network Gary,   Your scratch setting may be causing part of the problem.  Setting Scratch ON  means that all the sort files are being stored on the database directory which is the server.  So the scenario goes like this.... all the database info gets sent to the processor on the work station across the network, then back to the server for the sort files (scratch) generation, then back to the work station and so forth.   Set Scratch = C:\Windows\Temp (for XP) and all the temp files will be created on the desk top and thus eliminate a huge amount of network traffic.  This should help a fair amount.  Please note that the report will never run quite as fast over a network verses the local drive as there is a big difference in 100 mb speed of a network versus the bus speed of a computer.  However you should not see that big a difference and I believe setting your scratch files differently will help.   Good luck- _Bob   -------------- Original message -------------- > 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). >