If you are running Camelot3 on a Windows 2003 Server, and it seems to be running slowly, check the following:
1. If you have CPU that supports hyperthreading try disabling it to see if that helps. If you can multi-core a CPU (dual core, quad core), set the CPUAffinity setting in firebird.conf accordingly. To do this, you would modify the CPUAffinity entry in the C:\Program Files\Firebird\Firebird_2_0\firebird.conf file, referring to the comments in that file for that entry.
2. Turn off Volume Shadowing in windows for any partitions where database files reside.
3. If you have a large database, make sure that on the Clients/Contacts and Quotes/Orders list screens that you turn off the "Show Grid Before Search" option (open the screen, right-click on the grid, uncheck the "Show Grid Before Search" option). If you leave this check, then whenever that screen is opened, it runs a query that retrieves every record in your database, when really, you don't want it to do that if you have a large database. You just want it to give you the search box, and so then it will only retrieve the matching records.
keywords: camelot3 slow, runs slow, windows 2003, windows 2003 server, server slow, camelot3 runs slow, camelot3 runs slowly
Add to favorites