Slow using compute command

[ProcomSql]

We have developed an accounting program. One of the reports is getting a list of outstanding records for a certain date and time. There is no problem with the exact report.

The problem comes from the speed from one computer to another. On one computer the report is done anywhere from 45 to 55 seconds. On another computer it takes 5 minutes everytime.

The computer that does it fast is a notebook,
1.6 Pentium M, 512 RAM, 80 GB Drive, 100 NIC.

The slow comptuer is a desktop
2.8 Pentium 4, 1 GB RAM, 80 GB Drive and 100 NIC.

I had a third station try it and prior to formatting and reinstalling windows it was as fast the the notebook. The was as well a desktop exact same specs as the desktop above. Now this computer as well now is slow doing this particular report.

We are using VB .net 2003 with Crystal Reports 11 and SQL Express 2005

Any suggestions woudl be great appciated.

Thanks

Randy Joyce
support@wheygro up.com

If you need any other info please let me know

[ProcomSql]

I think I may have foudn my problem. It seems to be an issue with the ADODB.dll. I installed the lastest version on my computer and now this particular report seems to be workign better and faster now. Have to do a little more testing with it to see if this is the issue or not and see what happens.

If anyone else has some comments on this woudl be greatly appriecated.

Thanks
Randy Joyce
support@wheygro up.com