Skip to Content
0
Former Member
Dec 16, 2011 at 04:13 PM

CR2008: dbf performances

17 Views

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