help! Crystal Reports 7 very slow with pervasive

[cheerfulskeptic]

I'm running Pervasive 2000i and am having very slow connection issues. I have a regular IIS server and the reports are run on this server, connecting via CR7 to the pervasive database on another server. I'm using a regular Pervasive ODBC client DSN to connect. is there a faster way (ie, using OLEDB)?
thanks

 

[mirtheil]

Is the query used in CR slow outside of CR? If so, then you might want to make sure that it's optimizing on the proper indexes. OLEDB with 2000i is not any faster than ODBC. YOu might try the native Btrieve driver in CR.


info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[cheerfulskeptic]

Can you please post the steps I need to take to select the database, etc, using the Crystal Btrieve driver?
thanks

 

[mirtheil]

Well, I don't use CR myself but I believe there is a Convert function within CR that will let you select which Database driver to use.
What about the query outside of CR? Is it slow? Is the query slow through the PCC?
Is the query using indexes? This can be seen using the Query Plan Viewer (http://www.sys-con.com/tango/archives/0102/sneary/index.html).


info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[Smcmanus2001]

One way to optimise it, is to check the indexes. And use some sort of SQL Query tool, to make sure the Query runs quick. Its better to use the GUI sometimes, as Crystal reports does some funky stuff sometimes with the SQKL Query, if you have to get more specific with the SQL Query, you can specify the SQL Query, in the SQL Query Tool. It comes with it, but the preformance in Crystal Reports is exactly like your query with this tool. Sometimes the Linkages don't jive with what you've done in the SQL Statement you've created, when duplicated in Crystal GUI. One more problem could be left Outer Joins, a real slowdown if done wrong.