How long with a big DB?

[DumTech]

Preface: I'm learning this stuff as I'm having to support it, so forgive my ignorance...

I'm dealing with distributed reports generated by Crystal Reports 8. Data access via ODBC Visual Fox Pro driver and I'm told Active Data (which I thus far fail to grok) is used in some of the reports.
Obviously resources and the report itself are large factors, but does anyone have some rough estimates on how long it should take for a report to run from a DB with 30,000 records (DB is two tables, each 40+MB)?

I have noticed a couple of "Driver not capable" errors in the SQL.LOG at times after a couple of SQLSetConnectAttr commands...But I haven't the foggiest what the rest of the information in the log means...

Thanks for any help, insight, pointers, etc....

Matt

 

[kenhamady]

If the reports are distributed (as in compiled and run through the CR distribution expert) then they can't be using Active Data. Active data is passed from the application. Are you running these reports from a shortcut, from the Crystal Reports Designer or from an application?

If from an application using Active data, the data is being generated by the app, not by Crystal. The app is passing the data to CR. What language, and which integration method are you using.

Performance is up to the database, and how efficiently it interprets the SQL. What is the SQL statement for your report. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[DumTech]

I see what you're saying about Active Data, now that I've done some more reading on it. I guess I've been misusing distributed...

These are reports coming from an application. The most recent problem is that we've had reports "running" for 16 hours, more in some cases, I think.... With no sign of a report. Problem comes to tech support, of course, where we're trying to get a grip on what's actually taking place so as to troubleshoot. Our software's database and reporting functions have recently changed, and we weren't really briefed on what was involved in the changes made other than the fact it should be better.

The rest of your questions are addressed to my ignorance... I guess by language you mean in which language the software itself was written? Not sure...! Integration method? Not sure again... And SQL statement? The select statement?

I guess it'll be mighty difficult to get informative answers when I lack most of the necessary information, eh? Meanwhile, our developers are looking at modifying how the Active Data side of things is going to work, so it might (if I'm lucky) become a moot point.

Thanks for trying to help again, Ken. As in the ODBC & SQL thread I started, I wish I knew enough to make your attempted help worthwhile...