Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Crystal Report suddenly slow Post Reply Post New Topic
Author Message
Bullet
Newbie
Newbie
Avatar

Joined: 25 Apr 2008
Location: United Kingdom
Online Status: Offline
Posts: 5
Quote Bullet Replybullet Topic: Crystal Report suddenly slow
     Posted: 09 Oct 2009 at 2:31am
Hi Guys,
 
We've been running a report for a couple of years now and up and till the last couple of weeks it has loaded in 3-5 seconds but over the last week or two it's suddenly taking between 15 seconds and 2 and a half minutes.
 
The tables consist of an ODBC link between Sage Finance and Manufacturing.
 
I've found the table/joins that seem to be causing the slow down and I understand that the joins are not ideal (no indexs/primary keys) but we have not experienced this problem in all the time the report has been live.
 
I'm running this report on the server so it's not networking issues.
 
Also if it is a load issue then surely the performance would have been gradual but this problem has become apparent in a very short space of time.
 
Any ideas?
 
Cheers, Bill


Edited by Bullet - 09 Oct 2009 at 2:33am
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 12 Oct 2009 at 6:17am
have you added a large amount of data to the tables recently?  that would slow down retrieval. 
 
just a thought.
IP IP Logged
Bullet
Newbie
Newbie
Avatar

Joined: 25 Apr 2008
Location: United Kingdom
Online Status: Offline
Posts: 5
Quote Bullet Replybullet Posted: 20 Oct 2009 at 1:53am
Yeah unfortunately nothing so simple, strange thing is the report is very consistent regarding processing times. For some records it will return the information in 10 seconds every time and for other records it can take up to 3 minutes everytime. The mind boggles!!Confused 
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 20 Oct 2009 at 5:50am
The only other thing that comes to mind, since it happens here every now an then...we will get client data and it will eat all of our free space, then everything runs slow because there is no room on the server.
 
yeah, you would think that the degradation would have been gradual...
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.