What is the best way to configure my database connections to maximize the speed when refreshing the report. currently, to return 15 records it is taking 15 seconds. I expect this should take much less time like many other reports I have.
I am connecting to 3 dbf tables using the odbc (rdo) connection. see attachment showing the database expert configs in crystal reports 2013.
How else can I organize my connections to make the report run faster?DB-expert-configs.docx