List:General Discussion« Previous MessageNext Message »
From:iConnect \(Berlin\) Stefan Hinz Date:January 31 2003 12:06am
Subject:Re: timing
View as plain text  
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 <hinz@stripped>
  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" <mary.stickney@stripped>
To: <mysql@stripped>
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
> Mary.Stickney@stripped
>
>
> ---------------------------------------------------------------------
> 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 <mysql-thread131224@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-list_hinz=iconnect.de@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>

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