Application Speed

[wes4dbt]

I have just created a small .Net app with a small Access DB and it has 3 Crystal Reports. On my Vista machine the speed was fine. But the client has an older XP machine. Heres my question:

Why is it that the first time the app loads or the first time a Crystal Report is run there is a significant delay? The first time a report is run there's about a 30 sec delay. But after that the report runs in less than 5 sec.

I'm guessing it has something to do with loading the .Net framework files, but thats only a guess.

Is there something I can preload that would stop this initial delay?

Thanks for any information.

[formlesstree4]

What are the stats of the Vista & XP machines?

[wes4dbt]

Don't have the stats on the XP machine with me.
The issue that I'm really interested in is, Why does the Application/Report take so long to run the first time as compared to the second time, third, etc., and is there a way to improve the initial speed.
I've noticed this speed difference on many applications and machines.

thanks for the reply

[weirddemon]

The PC caches the information, typically, in the Prefetch folder, so that it's quicker to access each time.

When it comes to loading the data, any time, it depends on how you're doing it. I can tell you the SQL is generally quicker than Access, but a small database shouldn't see too many differences.

[GaryMazzone]

This has been my experience with CR since version 4. First time you run the report it is slow. After that the speed picks up. Complain to CR.... I have and got nowhere very quick

[Pradeep1210]

I've seen this problem with me. What I did is remove the printer settings that it usually saves by default and optimize it for web. This helped me and you can give it a try too. So probably it is something to do with printer settings.

[wes4dbt]

Thanks for all the replies,

Pradeep1210, I don't know anything about this,

What I did is remove the printer settings that it usually saves by default and optimize it for web

This not a Web application, does that makes a difference?

[Pradeep1210]

Thanks for all the replies,

Pradeep1210, I don't know anything about this,

This not a Web application, does that makes a difference?

I'm not sure about this and don't have any sources to cite either. This is purely based on my experience:

Printer settings are saved inside your crystal report file and the Crystal Report engine seems to use it for rendering the UI when loading your report for the first time. The rest of the times I assume it picks up from some cache.
Since in most of the cases, we don't need to print, removing those settings help.

You could give this a shot and see if it helps. Otherwise you don't have the solution to the problem anyways.

[wes4dbt]

Pradeep1210,

Thats an interesting concept. Where would I find information on how to do it?

Thanks for the reply.

P.S. - Still won't let me rate you

[Pradeep1210]

I don't have Crystal Reports on this machine, so I can just make guesses at present. But it should be somewhere in one of the menus. (probably File menu). Just check yourself and I'm sure you'll find it.
Open your rpt file in crystal reports, remove printer settings and save it. Then see if the problem goes away.

[Pradeep1210]

ok.. I found this link on msdn:
http://msdn.microsoft.com/en-us/libr...8VS.80%29.aspx

And this kind of confirms what I'm saying.

[wes4dbt]

Pradeep1210,

Good information. I gave it a try but it didn't make any significant difference. It was a good learning experience.

Thanks for trying.