[RBASE-L] - RE: What's up with this?

[Oma]

Lee,   I hate to let you know that this problem is with the way Windows handles the file security and is not an RBase issue! If you were running Novell server you would not have this problem.   I had the same issue with a multi user setup with 6.5. I changed from shared configuration and started using terminal services on a 2003 server over 1 Gigabit network!   If we connect using network sharing I would see a considerable drop in performance. The test application takes 8 second to query in Rbase Terminal services session and 68 seconds with shared connection.    I’ve tried everything that Windows tells you to do to optimize your file sharing on the 2003 server but it does not help improve performance!   There is a terminal services like application that is used for small offices it is called   http://www.thinsoftinc.com/   WinConnect Server XP runs on a XP box with a good processor and lots of memory you can get up to 21 users on it.   Rbase runs fast using this application and it keeps your software licenses and hardware costs down!   It is simpler to manage too!     Best Regards,     Oma Cox O.C. Services Inc. P.O. Box 5485 Brandon, MS 39047   662.820.7599 601.992.6785   www.ocservicesinc.com   From: rbase-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of Lee Bailey Sent: Monday, July 10, 2006 10:41 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: What's up with this?   Hello Dennis and Bernard-   Thanks for the response.   Actually, I did try the server thing.  I placed Windows Small Business Server 2003 on another 2.2 gig unit with 1 gig of ram.   I placed 3 high speed network cards in the server (1 for a direct link to machine #1, 1 for machine #2, and 1 for the router with DSL line), hoping for 10 times the transfer speeds minimally.  (Machine #1 and #2 also have 1 gig network cards).   Unfortunately, I figured out that Small Business Server 2003 cannot support 3 direct network card to machine hookups, and inevitably has to be tied to either a router or switch.    Tying machine #1, machine #2, and the server to the common 100 mbps router did not improve R-Base performance at all, despite the fact that both machines #1 and #2 have the applications and command files on them, and the server only contains the actual database.   Do you have any idea what kind of data transfer rate R-Base requires, when used on a network?  Is the router's 100 mbps enough, or is it causing congestion in the system?   Have you experienced the same types of difficulties when employing your applications in a network scenario?  What do the "big boy" clients do to avert this issue?   Thanks to all!   Lee   Bailey & Associates E-Mail: [EMAIL PROTECTED] Phone: 772-597-0040 Fax: 772-597-0043 ----- Original Message ----- From: Dennis McGrath To: RBASE-L Mailing List Sent: Monday, July 10, 2006 11:02 AM Subject: [RBASE-L] - RE: What's up with this?   I believe it all boils down to Microsoft's sharing methodology. Sounds like #1 machine is hogging access to the DB since it is on a local disk.   My best guess is that you need to have the DB on a server. You will still see a performance hit when more that one user is connected, but not so drastic as to call it a crawl. And all users should see a reasonable reponse time.   Peep-toPeer sharing of a db has always been a somewhat risky way to save money too. Much safer to have the DB on a clean server where the server is not having to handle a lot of tasks unrelated to the db.   Others here can probably give you more definitive technical info.   Dennis McGrath   From: rbase-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of Lee Bailey Sent: Monday, July 10, 2006 9:36 AM To: RBASE-L Mailing List Subject: [RBASE-L] - What's up with this? Hello All-   I’ve been monitoring the users group for a long time, and have been impressed with the expertise revealed in exchanged emails.  I am hoping that one of you networking gurus can point me in the right direction in solving a perplexing problem.   I have been an avid R-Base user since DOS 2.0.  I am currently running version 6.5, and have been for about 5 years.   Here’s the setup— Machine #1 is a 2.2 gighz 64 bit machine with 2 gig’s of ram.  Machine #2 is a 1.9 gighz 32 bit machine with 1 gig of ram.  Both machines are tied together via a router with a transfer rate of 100 mbps.  The router also provided access, by both machines, to the Internet via a DSL modem, also attached to the router.   The 20 meg database files (RB1, RB2, RB3, and RB4) are on machine #1, with application command files on both machines to speed processing in the common database.  Being an old R-Base guy, much of the programming is done via command files, crunching a lot of data, to achieve the full relational data base power.   Here’s the problem-- When machine #1 accesses the database as a sole user, the applications, command files, forms, reports, etc. run very quickly.  When machine #2 accesses the database solely, applications also run very quickly.  When both machines are utilizing the database simultaneously, machine #1 still works great (the data base is on this machine), but machine #2 drops to a painful crawl.   If both computers are utilizing the database, and machine #1 exits the database, machine #2 continues to work painfully slow, even though it has become the sole user of the database at that time.   Setting are: staticdb on, fastfk off, scratch off, multi on, ansi off, feedback on, rules off, rowlocks are used, column verify, and precedence on, sort menu on.   My thought is that at a transfer rate of 100 mbps between the machines, a slow response by machine #2 should never happen—no matter what.     Any ideas as to what is going on, and what can be done to rectify the situation?   Lee   Bailey & Associates E-Mail: [EMAIL PROTECTED] Phone: 772-597-0040 Fax: 772-597-0043