No indexes on certain fields?
We were seeing some absurdly slow performance with "FogBugz Version 3.1.9 (DB 328)" on NT on MySQL... page loads for showing a bug by number were taking 5 seconds (!).
That's the only one currently (the index on the ixBug field in the BugEvent table). It's in the mysql.sql file that gets shipped with FogBugz but since 3.1.9 mySQL isn't created by the installer, it is always a user import procedure. So indexes and the like aren't always created correctly. The next version of FogBugz will allow you to install a fresh mySQL database so from the beginning your indexes will exist.
Michael H. Pryor
Within the FogBUGZ download @2004-05-27 (FogBUGZ-Setup-319.exe) the distributed mysql.sql file creates an index for table BugEvent column ixBug for MySQL. However, there is no similar index in the distributed all.sql file for SQL Server.
Fog Creek Home