Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Windows 7 really slow with Crystal Report

17 Dec 2009   #1
rando1000

Windows 7
 
 
Windows 7 really slow with Crystal Report

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.


My System SpecsSystem Spec
.
17 Dec 2009   #2
whs
Microsoft MVP

Vista, Windows7, Mint Mate, Zorin, Windows 8
 
 

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.
My System SpecsSystem Spec
18 Dec 2009   #3
rando1000

Windows 7
 
 

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.
My System SpecsSystem Spec
.

18 Dec 2009   #4
TimStitt

Windows 7 Ultimate 64 bit
 
 

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.
My System SpecsSystem Spec
18 Dec 2009   #5
TimStitt

Windows 7 Ultimate 64 bit
 
 

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.
My System SpecsSystem Spec
18 Dec 2009   #6
zigzag3143

Win 8 Release candidate 8400
 
 

Quote   Quote: Originally Posted by rando1000 View Post
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+
My System SpecsSystem Spec
18 Dec 2009   #7
rando1000

Windows 7
 
 

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.
My System SpecsSystem Spec
19 Dec 2009   #8
TimStitt

Windows 7 Ultimate 64 bit
 
 

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.
My System SpecsSystem Spec
23 Dec 2009   #9
rando1000

Windows 7
 
 

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.
My System SpecsSystem Spec
23 Dec 2009   #10
TimStitt

Windows 7 Ultimate 64 bit
 
 

Quote   Quote: Originally Posted by rando1000 View Post
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
My System SpecsSystem Spec
Reply

 Windows 7 really slow with Crystal Report




Thread Tools




Similar help and support threads
Thread Forum
Acer crystal eye vs. windows 7
Noob here. So it seems that the built-in webcam on my acer extensa 5230e doesn't like windows 7 drivers. (apparently a long history here) My particular problem is that the camera shows up in device manager and reads as working normally. However there is no program/application I have used that...
Hardware & Devices
Acer Crystal eye driver Issue Windows 7
How are you guys? I'm having a problem with my notebook Acer Aspire 6920 since i installed my Windows 7.... The camera driver doesn't work....( Acer Crystal Eye Driver Camera) Does anybody had this problem? How did you guys solve this?? I tried already run as ADM.. but didn't work I'm...
Drivers
crystal report is very slow in windows 2007
we have the some problem when using the crystal report with windows 7 or windows 7 service pack . when loading the crystal report from application it takes 14 seconds in windows 7 and windows 7 service pack where as same things happens for 3-4 seconds in the windows xp or windows 2003 server . ...
Software
Slow PC, Health Report says Device Disabled but Dev. Mgr. says its ok
My PC has slowed to a crawl. Performance monitor says CPU is constantly 50-60% busy with nothing happening on the screen. System Health Report says A device is disabled preventing it from working properly.Details:The device, Officejet 4500 G510n-z, is disabled. If this device is no longer used it...
Performance & Maintenance
Crystal Report 7 Issue
When i am going to run crytal report 7 application from vb in one of my windows7 machine it works fine,at the same time we run same application on another windows 7 machine it shows an error "Can't find database dll".Pls advise where it is problem.
Software
ACER Crystal Eye and Windows 7
Hi All, I updated my ACER Aspire One 751 with Windows 7 HOME Premium. So far the system is running. Only the webcam gives me a lot of trouble. It was crystal clear while using Vista Home Premium, but now I have a fuzzy display, see attachment. Using the program or yahoo messenger can open the...
Hardware & Devices


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 13:54.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App