The warehouse is updated once a month at night , with data from the mainframe. no records are updated or added to these databases in any other way. It is strictly a report database. They reports are ordered from a website. A record is put into a database called ReportQueue the VB app checks the queue and runs the reports one at a time and emails them out.
Outlook Express is running in order to email the PDF files to the recipient. I can understand it being SOME slower , but not hours slower. Mary Stickney TAG-TMI Data Warehouse Programmer 402-474-7612 x 3099 [EMAIL PROTECTED] -----Original Message----- From: Jennifer Goodie [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 2:12 PM To: Mary Stickney; mysql list Subject: RE: timing You are positive there is nothing else running while you are trying to do your reports? Have you tried keeping an eye on the processlist to see where it is getting stuck and to make sure there is nothing else going on? Where does the production server get its data from? Are their updates going on while you are running your reports? Is the production server tuned for the type of complex queries you are running? -----Original Message----- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 12:02 PM To: Jennifer Goodie; [EMAIL PROTECTED] Subject: RE: timing 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 [EMAIL PROTECTED] -----Original Message----- From: Jennifer Goodie [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 1:57 PM To: Mary Stickney; [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 6:08 AM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php