VFP 7 and Citrix, horribly slow

[daveg9000]

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

 

[Mike Gagnon]

daveg9000

1.It shouldn't be that slow. But are they coming in from the outside? If so they are at the mercy of the lowest common denominator - > The speed of the line. We have an application on a Citrix (NT4 be that shouldn't make a difference) and 25 users all coming in at either T1 speed of 1.7 ADSL and the Outline is 1.7 ADSL, so the application is running at the speed of the outline (1.7), regardless of the speed of the CPU of the amount of RAM (sort of, it always helps).
2. Are the runtime DLL registered? Could this be a case of unregistered DLLs? It slows down the application.
3. Does the app run "normally" on a stand alone? Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[daveg9000]

1. Some are coming in from the outside, but it's slow when local inside users logon. They have a dual processor 1 ghz each with 1 gig RAM. It's slow with 2-9 users.
2. Registered DLLs, that I don't know. How do I tell on a Citrix box? Which files to register?
3. App runs just fine in a LAN (no Citrix) environment. App runs fine on Citrix if I remove the RI code from the DBC. I just pulled the RI code out of the DBC and put it into a procedure library EXE and so far no errors. I don't know if moving the RI will effect speed though.

-Dave

 

[Mike Gagnon]

daveg9000

1. Some are coming in from the outside, but it's slow when local inside users logon. They have a dual processor 1 ghz each with 1 gig RAM. It's slow with 2-9 users.

Yes but as I said what is the speed of the line?. If it a dial-up at 56k it would make quite a difference.

2. Registered DLLs, that I don't know. How do I tell on a Citrix box? Which files to register?

Hard to say, but was that application just copied or installed? Meaning that the VFP runtimes files are registered, so the app doesn't have to struggle to locate them every time it makes a call to it.

3. App runs just fine in a LAN (no Citrix) environment. App runs fine on Citrix if I remove the RI code from the DBC. I just pulled the RI code out of the DBC and put it into a procedure library EXE and so far no errors. I don't know if moving the RI will effect speed though.

RI codes are about 100 lines of code I'm not sure that would do it.

A)Do you have access to the server directly? Does the app run normally (faster) directly on the server? (Or I guess ask the client to test it)
b) Since Citrix client is constantly upgraded, it may be worth it to download the latest version of the client at Citrix.com. Novell had a issue like that a few years ago.
Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.