List:General Discussion« Previous MessageNext Message »
From:Mary Stickney Date:January 30 2003 8:02pm
Subject:RE: timing
View as plain text  
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

Thread
timingMary Stickney30 Jan
  • RE: timingJennifer Goodie30 Jan
    • RE: timingMary Stickney30 Jan
      • RE: timingJennifer Goodie30 Jan
        • RE: timingMary Stickney30 Jan
    • RE: timingMary Stickney30 Jan
      • RE: timingMary Stickney30 Jan
  • Re: timingiConnect \(Berlin\) Stefan Hinz31 Jan
    • RE: timingMary Stickney31 Jan
RE: timingDavid Brodbeck31 Jan
  • RE: timingMary Stickney31 Jan