my test results of the .18 version

Postby ben » Tue 29 Mar 2005 21:28

this update rocks!!
ben
 
Posts: 119
Joined: Wed 17 Nov 2004 19:48

Postby r34 » Wed 30 Mar 2005 02:52

Hi

I thought everyone would be interested in my test results of the .18 version.

As per my post at http://crlab.com/forums/viewtopic.php?t=732 , the .17 version had slowed down a lot from a much older version that I had.

Here are the results including the latest testing - all numbers are in Ms, and the triplets are V3.10.0.5, V3.50.17, V3.50.18. They bounce around a bit each run, but are pretty consistent. I'm using a table of 100,000 records in a local database.


Read Speed (ie select * where..)

1353, 3446 (!), 1067 - The major select bug has been fixed in V3.50.18!

Write spead (ie insert ..)

40043, 39022, 43055 ie V3.50.18 has slowed down inserts by about 10%. It is still much faster than the micoOLAP product though. Any thoughts why .18 might have slowed down on inserts?

Aggregate (ie select sum(..) group by ..)

136, 157, 136 - problem fixed.


In summary, you HAVE to download this release and install it!
r34
 
Posts: 14
Joined: Mon 28 Feb 2005 06:33

Postby ben » Wed 30 Mar 2005 07:13

r34, is your name "rudy". This r34 looks like a mysql expert guy in DevShed.
ben
 
Posts: 119
Joined: Wed 17 Nov 2004 19:48

Postby r34 » Wed 30 Mar 2005 08:12

ben wrote:r34, is your name "rudy". This r34 looks like a mysql expert guy in DevShed.

Nope, not him and not connected to devshed.

The r34 comes from the car I drive, a R34. If you are a car nut you'll know what one of them is, though if you are in the USA you would probably never have seen one... Think REAL fast... :-)

And yes, to the implied question, I do know a thing or two about programming, and databases :-)
r34
 
Posts: 14
Joined: Mon 28 Feb 2005 06:33

Postby Ikar » Fri 01 Apr 2005 06:09

> Write spead (ie insert ..)

> 40043, 39022, 43055 ie V3.50.18 has slowed down inserts by about 10%. It is
> still much faster than the micoOLAP
> product though. Any thoughts why .18 might have slowed down on inserts?

Most likely, the problem just is in improvement of Fetch performance. We have already corrected a small error that caused a delay in Insert execution.

If you send us complete small sample we could give you more certain answer.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Postby r34 » Tue 05 Apr 2005 03:52

use the exanple I sent in a month ago, as that's what I used.
r34
 
Posts: 14
Joined: Mon 28 Feb 2005 06:33

Postby Ikar » Thu 14 Apr 2005 15:25

Please try .19 build
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Postby r34 » Mon 18 Apr 2005 03:47

Here are the results including the latest testing - all numbers are in Ms, and the triplets are V3.10.0.5, V3.50.17, V3.50.18, V3.50.19. They bounce around a bit each run, but are pretty consistent. I'm using a table of 100,000 records in a local database.

Read Speed (ie select * where..)

1353, 3446 (!), 1067, 1040 - There seems to be a slight, but consistent, improvement from V.18 to V.19

Write spead (ie insert ..)

40043, 39022, 43055, 38000 ie not only has V3.50.19 fixed the V.18 write slow down, it now appears to be the fastest release yet :-).

Aggregate (ie select sum(..) group by ..)

136, 157, 136, 138 No change from v.18


In summary, you should download the V.19 release and install it

On another note, the writes above do one record at a time. This is the slow way of course, and batching them up 1000 at a time speeds up the write by a factor of three on my local database, and many times that on my remote database...


Given releases are coming out so fast - not a complaint, as we all like fast fixes to problems! - is it possible for you to add a Version() function somewhere so that our application programs can tell what version they are using????
r34
 
Posts: 14
Joined: Mon 28 Feb 2005 06:33


Return to MySQL Data Access Components