thanks. we are doing the data load today and will upgrade the MYODBC to 3.51 before we do it. This will be a good test as the load takes 6 hours on the current version.
Mary Stickney TAG-TMI Data Warehouse Programmer 402-474-7612 x 3099 [EMAIL PROTECTED] -----Original Message----- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 6:07 PM To: Mary Stickney; [EMAIL PROTECTED] Subject: Re: timing Mary, > The Production server has MYSQL 3.23 and an older version of MYODBC then I > have. > 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. Maybe this won't help too much, but I've experienced that in some cases MyODBC 2.50 is sooo much slower than MyODBC 3.51. An export I did from MS Access to MySQL (some 1.5 million records) took hours with 2.50, and only 3 minutes with 3.51. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Mary Stickney" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 30, 2003 3:08 PM 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 > > --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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