I use Crystal XI to query many databases in our organization. One of the databases is a MySQL (4.X) database. There is only 1 table in that database I run reports against with about 200,000 rows in the table.
My problem (and I've not spent as much time as I should learning performance tweaks in Crystal) is how slow this report runs vs my MS SQL and Access reports.
I've tried "Perform Grouping on Server" option in the database menu and it doesn't seem to make any difference in performance.
Can anyone provide some tips on what I might try to improve performance?
My problem (and I've not spent as much time as I should learning performance tweaks in Crystal) is how slow this report runs vs my MS SQL and Access reports.
I've tried "Perform Grouping on Server" option in the database menu and it doesn't seem to make any difference in performance.
Can anyone provide some tips on what I might try to improve performance?