How can I optimize my BusinessVision Client-Server SQL environment?
BusinessVision Client-Server Edition includes a robust Pervasive.SQL 2000 or 8.7 Database Server Engine which means that you don’t need to be running database servers on any of your workstation PCs (Pervasive Workgroup Engine). Only one computer should be running the database engine and that is your file server. Do this and you won’t have gateway delegation issues and your network and computers will run faster. In a Client-Server database environment all the workstation PCs require is the Pervasive client requesters to access data on any remote (server) engine. The Pervasive client requesters are installed by default with any Pervasive.SQL installation. So the objective is to install the Pervasive.SQL Workgroup Engine as required by BusinessVision, then disable the loading of the Workgroup engine on the PC.
