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
