Speeding up the datareader for crystal reports

Maybe it's just my computer, or the fact that I'm testing my program in Debug mode...

But my report is very simple and it searches in the DB to find all products that have the same FAMILY as the FAMILY_variable that the user has selected and then list the resulting products.

There are 26000 products in the DB and when I run the program it takes more than 60 seconds to generate the report which normally is only 1 page long.

Should it take this long? If not, how can I speed this up?

If run your application and run this Crystal Reports Data Reader function twice, does it take as long each time?

With .Net, the first time an operation is performed, its slower because it's being compiled. The second time it should be faster becuase its cached.

If that's helping it to go slower because its compiling, you might want to make that code a seperate component (.dll) and skip the IL code and fully compile it. It may loose some optimization, but sometimes you need it fast the first (and only) time you're going to use it.

I'd say another alternative would be to do a testrun through the procedure when you boot up, but if its a whole minute, I don't think people are going to want to wait that long.

If this isn't the issue, then posting your code related to the Crystal Report would probobly help.