Why is PERVASIVE ODBC performance so slow with Crystal Reports..?

[MJRBIM]

I am using CR-10 (PRO) and Pervasive ODBC Engine interface 9.50.77.02

Simple report requests take forever to process, and the w3dbsmgr.exe process runs up to 96% of my CPU while they are processing.

Which leaves me with 3 questions...

1.) Why is PERVASIVE ODBC performance so slow with Crystal Reports..?

2.) Is this normal for PERVASIVE ODBC performance...?

3.) Any tricks or work-arounds to improve performance...?

Thanks in advance!

 

[synapsevampire]

The first trick would be to post specifics rather than saying a simple report takes forever.

Did you think that someone would recognize what simple means, and would then post some brillaincy that would make it take less than forever?

I would guess that whatever you're adding to the record selection formula isn't being passed to the database, you can check using the Database->Show SQL Query, but it's silly to try to guess further at this sort of post.

-k