Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Extremely slow Post Reply Post New Topic
Page  of 2 Next >>
Author Message
mcelwainj
Newbie
Newbie
Avatar

Joined: 18 Oct 2010
Location: United States
Online Status: Offline
Posts: 21
Quote mcelwainj Replybullet Topic: Extremely slow
     Posted: 24 Nov 2010 at 3:03am
Not sure what is going on, even our IT guy is stumped.

All of the sudden the connections to the two databases I'm pulling from are so slow that CR ends up crashing. We've removed and reinstalled the software, removed and reinstalled drivers, and created totally fresh connections. It's only slow when selecting the database to build a report - or refreshing an existing report. Literally - after letting a report refresh over night - I came in the next day to see that CR had crashed. Any thoughts?
-Jeremy
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 24 Nov 2010 at 3:15am
can you query the data in the database using other tools without issue?
IP IP Logged
mcelwainj
Newbie
Newbie
Avatar

Joined: 18 Oct 2010
Location: United States
Online Status: Offline
Posts: 21
Quote mcelwainj Replybullet Posted: 24 Nov 2010 at 3:21am
Originally posted by DBlank

can you query the data in the database using other tools without issue?



Looking into that right now - assuming I cannot - what would that indicate?
-Jeremy
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 24 Nov 2010 at 3:30am
what is your set up?
DB type? seperate servers? deployment process? web servers involved?
Definately not my area but I have seen similar issues happen with:
- rogue queries that are just crushing servers so the performance is maxed out
- SQL server that ran out of space either in teh DB or operating system 
- run away transaction logs
- bad switches that kill data movement
- and some other stuff that I cannot think of right now
IP IP Logged
mcelwainj
Newbie
Newbie
Avatar

Joined: 18 Oct 2010
Location: United States
Online Status: Offline
Posts: 21
Quote mcelwainj Replybullet Posted: 24 Nov 2010 at 3:33am
Here is what I know

Pulling from two sources - both of which are ODBC. Two programs hold the data MUNIS and SSI - they are governmental accounting programs.

Pulling from a network server (about 25 feet away)

We've reset the server a few times to no avail - could it be a driver issue perhaps?
-Jeremy
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 24 Nov 2010 at 3:49am
Please take this all with a grain of salt as this is out of my area but:
as always did anything change in the whole environment at the time of performance degradation?
Is this the only thing on your network that is slowed or are there other traffic issues (maybe not as severe)?
my server is the same physical distance but we had some serious speed issues that ended up being various network/hardware issues:
e.g.server hardware failing, loose wires (tech tripped and pulled them), over heating component, bad array, failed router switch , and other stuff
Ask your network/hardware folks to review EVERYTHING that has been done to any part of the network set up, especially on the day you saw the issue (or weekend before if it was monday). 


Edited by DBlank - 24 Nov 2010 at 3:50am
IP IP Logged
mcelwainj
Newbie
Newbie
Avatar

Joined: 18 Oct 2010
Location: United States
Online Status: Offline
Posts: 21
Quote mcelwainj Replybullet Posted: 24 Nov 2010 at 3:53am
Thanks a lot - will do

It is interesting that it is only like this on my computer. On other computers speed is no issue. IT is saying they may just rebuild my computer from scratch and hope that fixes it. If it weren't for the fact others are not having issues - I would say its a server issue for sure. I'm thinking otherwise...I will post a solution once its found. Thanks again!
-Jeremy
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 24 Nov 2010 at 3:57am

I would log in on another machine (or install the software on another machine if you are the sole crystal developer) to test the theory of it being your machine before making that assumption, rebuilding and realizing it is not fixed after all that. Not to mentino wasted time.
IP IP Logged
mcelwainj
Newbie
Newbie
Avatar

Joined: 18 Oct 2010
Location: United States
Online Status: Offline
Posts: 21
Quote mcelwainj Replybullet Posted: 26 Nov 2010 at 3:30am
OK - logged in to three different machines - no issues whatsoever. It's something with my machine/the connection with my machine. Once I find a solution I will post it here just for the FYI. Thanks again!
-Jeremy
IP IP Logged
JohnT
Groupie
Groupie
Avatar

Joined: 20 Jan 2008
Online Status: Offline
Posts: 92
Quote JohnT Replybullet Posted: 30 Nov 2010 at 5:02am

You might also try connecting your PC to another network connection that works fine for another computer.  If it is slow for you, could be your network card etc.  If it is fast for you, it must be your connection.

IP IP Logged
Page  of 2 Next >>
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.