CR2008: dbf performances

[Former Member]

Hi everybody,

I've got a question about performances in CR2008. I've defined an ODBC datasource on some dbf files (Microsoft dBase driver); in my report I use three tables, and query resulting is the following:

 SELECT `D_LISART`.`LISART`, `D_LISART`.`CODART`, `D_LISART`.`CODCF`, 
`LD_CODCLI`.`RAGSOC`, `M_ARTICOL`.`DESART`
 FROM   (`D_LISART` `D_LISART` INNER JOIN `M_ARTICOL` `M_ARTICOL`
 ON `D_LISART`.`CODART`=`M_ARTICOL`.`CODART`) INNER JOIN `LD_CODCLI` 
`LD_CODCLI` ON `D_LISART`.`CODCF`=`LD_CODCLI`.`CODCLI`

If I run a report preview in CR or report in viewer, it tooks about a couple of minutes... but if I run it with another external tool, connecting to the very same odbc source, it tooks just some millisecs... records in tables are few, so this "timing" it's unexceptable... is there something I can do to speed up my report?

I've googled around, and found that best practices suggest to use indexed fields, but I already do this...

Thanks in advance

Gio

[Former Member · Accepted solution]

Hi

You said when you run through external tool .. What is this external tool ? Normally ODBC will take little time to carry the instructions to your database.

Try connecting through file type database connections -- Access / Excel (ADO) and select dBase file type and try to run your report.

Thanks,

Sastry

[Former Member · Accepted solution]

Hi,

I've found this "SQL Query Tool (using ODBC)" - that's the name - which allow me to connect to an ODBC data source and run a query on it...

In CR/DB Expert, datasource is created as ODBC (RDO). If I didn't misunderstand, you suggest to use every single table as a different datasource (i.e. in DB expert choosing OLE DB (ADO) and then Jet OLE DB...); but this way I've to "hard code" table path in report, and specify every single table... that's not what I need, a single datasource is better..

Thanks again

Gio

[former_member11696]

Try turning on ODBC Tracing and then compare them between CR and the ODBC test tool.

See where the delay is, in CR getting the data or processing the data client side.

Don

[Former Member]

Hi Don,

I've tryed run tracing for both, but logs are very different (also in size!)...

I look for "select" instruction and in tool's log I found it at line 2027 (of 4122 total lines), while in cr I found it at line 18433 (of 23446), but I don't know well how to read them... what should I look for?

thanks in advance

Gio

[former_member11696]

Hi Gio,

Now that the holidays are over and I've caught up I suggest you purchase a support case and discuss with a Rep...

Unless you know what to look for the logs need to be reviewed by a Rep here.

http://store.businessobjects.com/store/bobjamer/en_US/DisplayCategoryProductListPage&CategoryID=5598...

Thanks

Don

[Former Member]

Hi Don,

finally running some "random" test on CR options I found what was wrong with my report!

Unchecking "Verify on first refresh" in File\Report Options menu, really speed up my report!

Thanks for all the support!

Gio