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