>They run in 8 minutes on my test server , about 4 minutes each. Printing to
>a PDF driver.
>On the Production Server they take HOURS to run and print.
The production server is probably trying to do other stuff at the same time,
making your reports slower. A machine with one active connection will run
queries a lot quicker than an identical machine with 50 connections. Think
about what happens when you try to do 50 things at once :)
Is the test server using a localhost connect and the production not?
Localhost is a lot faster than TCP/IP when running a large amount of
From: Mary Stickney [mailto:mary.stickney@stripped]
Sent: Thursday, January 30, 2003 6:08 AM
I have 2 Crystal Reports 8.5 (for the record I didn't make these reports)
that draw straight from the MYSQL
database. They use only 1 table. I am calling them to print from VB 6.0
Theses reports have lots of complex calculations in them, counts , sums and
My test server has the same code , same database , same indexes , same
amount of memory as the Production server,
My test server has MYSQL 3.23.51 and MYODBC 3.51 , and I have Crystal
installed on my test server.
The Production server has MYSQL 3.23 and an older version of MYODBC then I
No Crystal Reports installed. And the server is a faster machine then mine.
They run in 8 minutes on my test server , about 4 minutes each. Printing to
a PDF driver.
On the Production Server they take HOURS to run and print.
Data Warehouse Programmer
402-474-7612 x 3099