no it is dedicated to the DataWarehouse Report Processor.
runs one report at a time from a ReportQueue.
both have a local host.
Mary Stickney
TAG-TMI
Data Warehouse Programmer
402-474-7612 x 3099
Mary.Stickney@stripped
-----Original Message-----
From: Jennifer Goodie [mailto:goodie@stripped]
Sent: Thursday, January 30, 2003 1:57 PM
To: Mary Stickney; mysql@stripped
Subject: RE: timing
>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
queries.
-----Original Message-----
From: Mary Stickney [mailto:mary.stickney@stripped]
Sent: Thursday, January 30, 2003 6:08 AM
To: mysql@stripped
Subject: timing
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
groups.
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
have.
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.
Any ideas...
Mary Stickney
TAG-TMI
Data Warehouse Programmer
402-474-7612 x 3099
Mary.Stickney@stripped
