Have you tried moving the menu database into tables with the production database? You should loose nothing in performance. Perhaps there is some Win 2000 issues with later versions of Windows clients or the newer PC architectures in database handling when jumping between the two databases.
Just what I would try next. Ike At 01:33 PM 11/26/01 -0500, you wrote: >Hi All, > >Last June I requested help for a client who experienced >a drastic slowdown using an R:Base application when other >network users are attached to the database. >Finally after trying several things (see below), I have >the bad news that nothing has helped. > >To recap the problem and possibly clarify the situation: > >1. Their Server is Windows 2000. >Most work stations are Windows 98; a few are Windows 95. >Most, but not all, of the Windows 98 computers are the problem. >The slowdown problem occurs on the newest and fastest computers >but not on some older ones. >One of the slow computers is a new PIII-800 while one of >the faster computers is an older Pentium-166. > >2. The application being used makes use of a separate menu database >for a rather extensive menu. Therefore there is a constant moving >back and forth between the main database and the menu database. >**This seems to be the point where the slowness occurs, >**opening the database. I did not know this last time I requested help. > >3. There is not a slowdown problem at all (on any computer) >as long as there is no OTHER R:Base application user on the network. >When working from one of the "SLOW" computers, it works fine until >someone else logs into the R:Base application. Once the 2nd user >exits the application, the speed returns to normal for the one user. > >Thanks to all who tried to help last June with I first started this. >I passed along advice and implemented suggestions given at that time: >As per Rich Young's advice, I set scratch file to local computer. >As per Lawrence Lustig's advice, I referred them to web sites dealing >with Windows 2000 setup. >As per Nicky Avry's suggestion, I had them swap network ports; the >problem >stayed with the computer not the hub. >As per Anthony Schmidt's note, I only have TCP/IP. > >Albert Berry, did you find a solution to the similar slowdown problem >you reported back about the same time(June)? > >Just a note, she did mention that they are not having any of these >problems with some rather large ACCESS databases! We can't let R:Base >look like the bad guy because we know it is really the good guy.
