rraehal
01-21-2004, 06:13 PM
I have Crystal Reports Installed on My Webserver. Windows 2000, IIS 5, PHP, MySQL, etc....
I have set up CR to connect to a MySQL database. Unfortunatly I was forced to use ODBC. The problem is this:
When I use SQL to access my databases, I can pull 75 full records in .2 secords according to SQL. When I use CR9 to pull the report it takes about 3 or 4 seconds to pull 2 pieces of data (username - 25 CHAR and accesslevel - Number) from single records. (75*3=150) It takes me about 2 minuets to generate a 2 page report. It is fatser for me to look at the SQL tables and print them at this point.
The question I have is this due to the fact that I am using ODBC with CR9 or should I look for some options to speed things up.
I am using CR for the first time. I am going to connect to a database at a remote location that is ran by Oracle when I have learned what I need to know. If this slow data retrieval is going to continue I may need to do something else before generating these custom reports.
I have set up CR to connect to a MySQL database. Unfortunatly I was forced to use ODBC. The problem is this:
When I use SQL to access my databases, I can pull 75 full records in .2 secords according to SQL. When I use CR9 to pull the report it takes about 3 or 4 seconds to pull 2 pieces of data (username - 25 CHAR and accesslevel - Number) from single records. (75*3=150) It takes me about 2 minuets to generate a 2 page report. It is fatser for me to look at the SQL tables and print them at this point.
The question I have is this due to the fact that I am using ODBC with CR9 or should I look for some options to speed things up.
I am using CR for the first time. I am going to connect to a database at a remote location that is ran by Oracle when I have learned what I need to know. If this slow data retrieval is going to continue I may need to do something else before generating these custom reports.