Citrix, Opening a database, incurs delay?

[Big2]

Hi Guys,

Got something which has been bugging me like mad for weeks now;

We have a MS Access Database on a Citrix server and a local copy is downloaded to the clients directory when they log on.

When they actually double click and load the database(frontend) it loads for approx 4/5mins before it eventually opens. After that it is fine, unless they log off and back on again, then the same thing happens when they double click to open the database.

The Backend is stored on a seperate server with over 5million records on it.

Before we attempted Citrix we had a normal network and the frontend has always loaded fine on this.

Any ideas?

Thanks.

 

[The_Doc_Man]

Your description is ambiguous. Where is Access running? (Rhetorical question, here are the choices.)

1. No Access exists on client system, they run the CITRIX environment and the application runs entirely on CITRIX. Your problem is that CITRIX needs to allocate swap space, free up some memory for a BIG hompin' database, and let the startup code run to completion. Not trivial.

Also: What gets downloaded? CITRIX client software? Shouldn't have to be downloaded every time, first connection should do the trick. And downloading your application front-end to the client box does you no good if Access is running on the CITRIX box.

Worst possible scenario, and I'm not sure this is even possible: Access is running on CITRIX box using YOUR box as the (reverse) file server to the front end and running the back end locally.

2. Access is running on the client. You are just using CITRIX as a file server whether you wanted to or not. If there is a performance problem it is because CITRIX has lots of other things to do. Look to the memory available to CITRIX and do a performance analysis for excessive swapping.

Send a file server to do a file server's job.