|
Hello All-
Ive 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. Heres the setup Machine #1 is a 2.2 gighz 64 bit machine with 2 gigs 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. Heres 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 happenno matter what. Any ideas as to what is going on, and what can be done to rectify the situation? Lee
|
