Dear reader,
How to speedup the performance of a MS Access application on a Citrix
server.
The performance is dramatically slow also on the new 64 bid Citrix server.
Thanks for any suggestion.
Regards, Simon

On Mon, 8 Nov 2010 23:16:19 +0100, <svanbeeknl (AT) hotmail (DOT) com> wrote:

Where is the Access user specific front end stored? Is it in the
users home folder which could be anywhere in the world? Or is on the
Citrix server or a file server on the same LAN as the Citrix server?

Tony

--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

Per <svanbeeknl (AT) hotmail (DOT) com>:
You are not alone.

I moved an app from LAN server to Citrix to speed it up - over a
year ago.

After the move, it really did run faster - and kept running
faster for several months.

But eventually it became slower - even with regular
compact/repairs. Now I am pretty sure that it runs
significantly slower than with the back end on a LAN file server
and the front end on the user's PC.

After looking in to it with the Citrix experts in this
environment, I came away with the impressions that:

- The experts don't know as much as I had hoped. They can fool
around with the session's memory allocation and stuff like that
but when you down to asking why it's slow they do not have any
answers/theories.

- At least where I am, the Citrix "Server" is really a
virtual PC on some humongous box somewhere.

I know nothing, but it seems logical to me that said box
only has so many MIPS to spread around and the more "Servers"
are on it and the more people are beating on said servers, the
poorer my app's response time is going to be.

I'm guessing there can also be issues with disc
access/location, but that is also way, way beyond my
job description.

I have had similar issues after moving a back end to SQL Server.
Same deal: the server is a virtual PC on one of those mega boxes
and I've lost control of resources available and who uses them.

For both Citrix and SQL Server, the
"Server-Under-Somebody's-Desk" idea has a lot of appeal to me.

I could control who is beating on it, and I could throw money
at performance issues.

Only time I've tried it was doing a SQL Server backend project
for a bunch of engineers in a big electric utility.

Who managed the care and feeding of the server wasn't my problem
in that case... which was a Good Thing bc I am not qualified to
do something like that. But performance was way, way better
than anything I could do against a .MDB on a file server

Ditto when IT brought in a .NET developer to port one of my
apps to .NET/SQL Server. As long as the new app was running
against the PC on the next desk, it was lightning fast - as in
sub-second response time for all screens.

But once they went into production, my app was faster and users
were complaining about slow response time - even with only one
user.
--
PeteCresswell

"(PeteCresswell)" <x@y.Invalid> wrote in
news:n8mid61cvhj5h8oqljspiftbm3tf2q6gi6 (AT) 4ax (DOT) com:

This is very bad and I would never want to run an Access app in any
kind of virtual environment.

Of course, I'm assuming they are virtualizing the HDD too, which
would make a very neat and tidy explanation of why it starts out
fine and then gradually slows down.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

I am running Access 2010 in a virtual environment without problems. Pete is
correct about the server. As long as it is on a speedy box, it's fine. When
the admins tried to move it to a "secure" box (meaning one they had more
control over) it slowed to a crawl. Fortunately the department was key to
the organization, and the users forced it back on their local workgroup
server.

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access Solutions", published by Wiley


"David-W-Fenton" <NoEmail (AT) SeeSignature (DOT) invalid> wrote