Gary, One thing that helps, 15,000 RPM SCSI drives in a RAID 5 or 6 configuration.
If reports take too long to print in a multi user setting you could make a local copy of the database and connect to it temporarily as a single user. I think you need to change directories before you disconnect or the disconnect takes a lot longer....I think another user with lots of experience mentioned that trick. I noticed the same performance issue many moons ago when I moved from Novel Netware to Windows Server. Mike On Aug 4, 2012, at 12:28 PM, "Gary Wendike" <[email protected]> wrote: > I am sure this topic has been discussed before, but I am just waking up to > the fact I need to gain more speed across the network. There are some > things that will work OK as far as speed. Those are primarily forms where I > just need to view data or reports where the table already exist. > > My current configuration is… > 1. I have RBase installed on each pc and access the database files > located on a server. > 2. I have the latest version of 9.5 > 3. Database size is 5gig > 4. Table size can vary from 500 rows to 14million rows > 5. 1 gig network cards > > Where I need to improve on the speed involves reporting when data has to be > generated. If I run some reports from the server it can take 30 seconds to > generate the data and report. If I am the only one on the network and run > from my PC it can take 5 times as long. If someone else is on the network, > it can take 10-15 times longer. Also, if I load data, it is always faster > to load from the server than to load from the local PC. > > All PC’s operate pretty much the same as far as speed. In other words, I > don’t have a problem PC. > > I would like to know how people have gained the speed for the database to > operate…Is it better to > 1. Have the program setup on each PC like I have or > 2. Have everyone Remote into the server and have all the operations > performed via that connection. > Could you give me your pros and cons of each. > > Thanks for your input. > > Gary > >
