Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Slow Refresh when Linking Post Reply Post New Topic
Author Message
vesperka
Newbie
Newbie


Joined: 29 Apr 2009
Online Status: Offline
Posts: 8
Quote vesperka Replybullet Topic: Slow Refresh when Linking
    Posted: 04 May 2009 at 7:41am
I have two databases with about 32,000 records each. If I display one field from either database into my report it loads almost instantly. However, if I choose to display one field from each report, my preview screen updates at about 6 records per second. I'm using the standard linking options. Is there anything I can do to make this run faster?
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 04 May 2009 at 1:53pm
What type of database are you using? 
 
-Dell
IP IP Logged
vesperka
Newbie
Newbie


Joined: 29 Apr 2009
Online Status: Offline
Posts: 8
Quote vesperka Replybullet Posted: 05 May 2009 at 10:41am
One database is from Excel 2003 and the other is from Access 2003.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 05 May 2009 at 10:53am

Because these are both file-based databases, the join logic, filtering, etc. is all handled by Crystal itself.  This means that Crystal has to go through all 64 K records (32K per file) and figure out how they match up.  There is no way to speed up this process in the form that you have.  You might be able to load the Excel spreadsheet into a table in the same Access database as the rest of your data which would probably speed things up.

-Dell
IP IP Logged
vesperka
Newbie
Newbie


Joined: 29 Apr 2009
Online Status: Offline
Posts: 8
Quote vesperka Replybullet Posted: 05 May 2009 at 11:40am
Good Call! Importing external data was a piece of cake in Access so I was able to have all of my records in one database. Loading the entire table takes maybe a couple of seconds now Big%20smile
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.047 seconds.