Windows 7 really slow with Crystal Report

[rando1000]

I recently replaced a computer in our small office running windows xp with a new one running windows 7. The xp machine was an old P4 with 512 mb of DDR RAM. The new machine is an Athlon 64 with 1 gb of DDR2 RAM. So, in general, much faster machine.

BUT...we have a proprietary piece of software that runs Crystal Reports from a gui and queries a SQL server. For some reason, in Windows 7, I get the spinning blue wheel for about 40 seconds before it pops up the results of the report to the screen (took about 3 seconds on the old P4 in XP). If the same report is sent directly to the printer, however, it comes out almost instantly. I plan on contacting the software vendor, but I was curious if anyone has a suggestion of what might be making this take so long, or even how I could find out.

 

[whs]

1GB for Win7 is really pushing it. Put at least another Gig in - better even 2 additional GBs. You cannot compare the XP appliance with a modern system. Think of all the things that Win7 does automatically that you had to do by hand on XP.

 

[rando1000]

My mistake. The system's running 2 gb of ram. Now, the computer's not doing anything else, at all really, except running basic office applications. It's not using up even a substantial portion of 2 gb of ram when this happens. So, I don't think it's ram related.

 

[TimStitt]

Hi rando1000,

Which version of Crystal Reports are you using and which version of SQL? Also is the SQL database on the WIN7 box or separate?

It interesting that the report comes out quicker direct, this was often the case with versions 6 & 7 of Crystal.

I've got no answers yet, but I'm hoping we can put together some theories.

EDIT - I just re-read the SQL server is separate.

 

[TimStitt]

Some other thoughts: Your scenario makes me think that the response is slower from the SQL Server. So also look at what has changed that could cause a higher bandwidth usage than you had previously.

e.g 1 Your program installed locally but is running from a shortcut that goes direct to an *.exe of the program on the SQL server (you may laugh, but this is common in installations), so the program EXE is running over the network.

e.g. 2 A problem with IPv6 - drop back to IPv4 and see if it works better.

e.g. 3 DNS resolution. When configuring an app with an SQL database, I have often received better results when using the IPADDRESS of the SQL server instead of the servers name.

That's all I can think of. Good luck.

 

[zigzag3143]

I recently replaced a computer in our small office running windows xp with a new one running windows 7. The xp machine was an old P4 with 512 mb of DDR RAM. The new machine is an Athlon 64 with 1 gb of DDR2 RAM. So, in general, much faster machine.

BUT...we have a proprietary piece of software that runs Crystal Reports from a gui and queries a SQL server. For some reason, in Windows 7, I get the spinning blue wheel for about 40 seconds before it pops up the results of the report to the screen (took about 3 seconds on the old P4 in XP). If the same report is sent directly to the printer, however, it comes out almost instantly. I plan on contacting the software vendor, but I was curious if anyone has a suggestion of what might be making this take so long, or even how I could find out.

Hi and welcome

Crystal reports brings back some memories. Are you running workgroup or homegroup? IPv6, or IPv4?

im thinking dns/dhcp.

Ken J+

 

[rando1000]

Thanks all. In answer, it's Crystal Reports 11, SQL Server 2000, the Server is on a separate computer. None of the XP machines on the network experience the problem, so I'm pretty sure it's not a bandwidth issue. It could well be an IPv6 issue; I hadn't thought of that. My nightmarish experience with IPv6 and my Linux e-mail server should have tipped me off. I'll try disabling that and see what happens.

 

[TimStitt]

Great! let us know how you go with IPv6. Also check if it's being virus scanned, maybe add an exception for the default Crystal report folder and (if you can safely) incoming SQL connections.

 

[rando1000]

Okay, finally had a chance to try disabling IPv6 following this method: Simple Way to Disable IPv6 in Windows Vista. No luck there. To zig-zag; cant's be dhcp - the network is all hard coded ip addresses. Not sure about dns.

 

[TimStitt]

Okay, finally had a chance to try disabling IPv6 following this method: Simple Way to Disable IPv6 in Windows Vista. No luck there. To zig-zag; cant's be dhcp - the network is all hard coded ip addresses. Not sure about dns.

I wish we had something more concrete.

Hmm.. what about DNS?
- You could always add an entry to the hosts file on the Win7 box for the SQL server
- Also add the dns suffix manually to the win7 box by hitting the MORE button on the computer name/domain screen.

I'm just trying to think of anything that could speed it up, even a millisecond or too.

If neither works, you could always remove them.

Other thoughts to help us narrow this down

On the application, check where the default temp file or report repository is. If the Win box is creating a report and saving it on a network location, this will slow things down. Also if it is not storing the *.rpt files (the blank coded reports) locally it would be slow.

Ping -t test to the SQL server from the Win 7 to see if it is slower or drops packets.

MS Excel test - open excel and do a long query to the SQL database via ODBC, verify the same query on another machine. If the Win7 box is slower then the problem is unlikely to be application related.

Good luck and Merry Xmas

 

[MyWin7]

It's not just Crystal report - it's something to do with database access and putting it to screen!

The designer software my wife is using is exposing very similar habits - it worked fast up until Vista but since Win7 loading the stitch library (part of the software) slows down to about one stitch a second makes loading the program a bit of a pain. I had a look into the error log and found occurrences pointing to MFC42.DLL

Faulting application name: Easyc.exe, version: 7.2.0.1, time stamp: 0x4631f22e
Faulting module name: MFC42.DLL, version: 6.6.8063.0, time stamp: 0x4a5bda30
Exception code: 0xc0000005
Fault offset: 0x00026ee5
Faulting process id: 0xa58
Faulting application start time: 0x01ca7c242f0a1136
Faulting application path: C:\PROGRA~1\EASYCR~1\Easyc.exe
Faulting module path: C:\Windows\system32\MFC42.DLL
Report Id: 75d17c41-e817-11de-bb84-001b2f2bb7a3

 

[rando1000]

Thanks for the idea. I will try looking at the event viewer (should have thought of that; too used to linux where errors like this are a bit easier to find) when I get back to the office on Monday.

 

[argeraju]

Crystal Report (8.5) on win7/windows 2008 64 bit system

Crystal Report (8.5) is not working on win7/windows 2008 64 bit system

My application is a vb application and I am using Crystal report 8.5. It is working fine on 32 bit system and 64 bit system of Windows 2003 server. When I run the same application either on win7 64 bit or on 2008 64 bit, report does not open.
I am using vb script to access the database.
Part of the code written in the VB script file is as follows:
Dim objrsRecordSet 'As RecordSet
Dim strSQL 'As String

'**** Open Database Connection using the parameters passed from the main program
Set dbConnection = CreateObject("ADODB.Connection")
dbConnection.ConnectionString = "Provider=SQLOLEDB;Server=" & mstrServer & ";uid=" & mstrUserName _
& ";pwd=" & mstrPassword & ";Database=" & mstrDatabase & ";"

dbConnection.Open
dbConnection.CommandTimeout = 200

dbConnection.Properties("Enable Fastload").Value = True




Basically we have two visual basic projects developed in VB 6.0 language: let’s say
1. Diapp (we consume the report.dll in this application, in order to generating the reports)
2. Adacrystalapp (which is used for making the report.dll)


Diapp application generating the reports on windows-XP(32 bit machines) without any problems but when I run the same application on 64 bit machines(win7/Vista…etc) report is not generating.
If I run the both applications (Diapp, Adacrystalapp) in debug mode then reports are generating on 64 bit machines (win7/vista) also without any problems.




Please help me out with this issue, i will appreciate for your response.