A couple of my customers are running Citrix Metaframe v1.8 Windows 2000 and have the program folder and data folder (contains DBC and tables) on the same Citrix server. The speed of the application is horrible, sometimes 30 minutes to open a grid to look at 2500 records! The same application (no changes whatsoever) runs on a LAN with another customer with 14 concurrent users at a decent speed (they never complain).
All I could find on the web about this were a couple suggestions (one from Yair Griver) to move the data to a Novell server.
Does anyone have any suggestions? I believe the "supercache" is enabled so having BITMAP=OFF in my config.fpw file would be unnecessary (even though I tried that).
I can tell you I disabled the referential integrity in the DBC (put RETURNS in each procedure) to test and that made the whole application run fine.
Should I take the RI out of the DBC and put it into a PRG that is part of the application so I can keep RI but not slow down the DBC?
Any tips, suggestions, "try this or that" will be greatly appeciated.
- Dave
All I could find on the web about this were a couple suggestions (one from Yair Griver) to move the data to a Novell server.
Does anyone have any suggestions? I believe the "supercache" is enabled so having BITMAP=OFF in my config.fpw file would be unnecessary (even though I tried that).
I can tell you I disabled the referential integrity in the DBC (put RETURNS in each procedure) to test and that made the whole application run fine.
Should I take the RI out of the DBC and put it into a PRG that is part of the application so I can keep RI but not slow down the DBC?
Any tips, suggestions, "try this or that" will be greatly appeciated.
- Dave