Gary,
Some tips: 1. If the report is based upon a table with a lot of rows, think about creating a temp table, which contains only the selected rows. Make sure that this temp table is stored locally. Then run the report based upon this temp table. 2. Have a look at the virus scanner, you probably can exclude files with the extension RX1,… RX4 and maybe even more important the $$$ files. 3. Have a careful look at the used indexes, especially in the tables with a lot of rows. 4. Running the application with RDP is an option. It depends on the number of users. You could consider to start with this option and switch to the other solution when the speed is ok. The advantage of using RDP is that you don’t need a high speed connection, on the other hand the number of concurrent users could become a bottle-neck. 5. It was mentioned once it is preferred to have only the database in the database directory and not too much other files. 6. Have a look at your settings like staticdb on, fastlock, etc. Tony From: [email protected] [mailto:[email protected]] On Behalf Of Gary Wendike Sent: zaterdag 4 augustus 2012 18:29 To: RBASE-L Mailing List Subject: [RBASE-L] - Net Work Speed 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
