Tom, Just some thoughts from somebody that has used Rbase for 20+ years. For most of those years I was using only as single user, about 3 years ago went multi-user, now have about 8 machines running. One of the main things I have learned(mainly from the great people on this message board) is to use temp tables and inserting alot. Even now I'm speeding up the database by using temp table for about everything, as an example I have alot of popup menus in my data entry forms. recently I have created temp tables from the permanent table for the pop-ups. This did increase my network speed some, every little bit helps. Tom Hart
----- Original Message ---- From: Tom Frederick <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Wednesday, July 16, 2008 1:31:10 PM Subject: [RBASE-L] - RE: Multi user R:Base on a LAN Emmitt, Lawrence, Dan, Paul Thank each of you for your feedback. I remember Razzak’s info, but we were far from ready to go that route at that time. I will find that. We will likely play with both approaches for a bit. Upgrading equipment may be financial sticking point right for some slow machines, but the gigabit terminal server approach has appeal. Each of these steps brings more issues and more complications. I know my first step is going back into the program and making sure to use the ‘temporary’ status as required. It is fun to see this thing work and have people like it, but they always want more. Tom Frederick ElmCity Center 1314 W Walnut Jacksonville, IL 62650 Off - 217-245-9504 Fax - 217-245-2350 Email - [EMAIL PROTECTED] Web - www.elmcity.org ________________________________ From:[email protected] [mailto: [email protected] ] On Behalf Of Tom Frederick Sent: Wednesday, July 16, 2008 10:06 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Multi user R:Base on a LAN We are moving our internal database project from our single user development machine out to 20 machines and eventually to users not directly connected to our LAN. Using Turbo8 compiler because of several other projects that have been requested. LAN is a mixture of speedy machines and some dogs that will need to be replaced at some point. Server works very well. We expect numerous problems based on the “didn’t know I did not know that” paradigm. Our system works great on a single computer and has required “some” changes as we start moving to multiple machines. More will be coming. The differences between single user vs. multi user becomes very obvious once it does not work (particularly in demos) and you have to figure it out. Just part of the learning process. Our question (which may seem very basic): Is there a best way to set up multi-user R:Base on a LAN system? Data is on Drive Y where we can secure direct access from inquiring mice. Is it best for the EXE/DLLs to also be on Drive Y or remain on individual machine’s Drive C to access the Drive Y database. We have tried both ways and they work. The concern is LAN speed (particularly for some older computers) and conflicts between tables/temps/views that the software uses. It seemed having one network based EXE that multiple people can access would really effect our LAN speed/memory, while separate EXE/DLLs on desktops isolate some memory processes and be primarily limited to moving data. I have no doubt we have a lot to learn about data and logic conflicts as we go through this. I remain amazed at just how much DYI groups like us can do with R:Base with some time, interest, and willingness to learn. Tom Frederick ElmCity Center 1314 W Walnut Jacksonville, IL 62650 Off - 217-245-9504 Fax - 217-245-2350 Email - [EMAIL PROTECTED] Web - www.elmcity.org
