× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Tim,

If you leave off the "Hi Mike" we are at 244 words. I can live with
that.

This is exactly what I was looking for. And given that you are
reasonably impartial to the testing parameters (i.e. I did not ask you
to compare DB2 to MySQL) I grant you full credibility in your statements
:-)

Thank you for the honest feedback as it sounds like 64-bit is certainly
the way to go! But, as always YMMV!

Woohoo!

Regards,

Mike

mike.p@xxxxxxxx Cell: (408)679-1011 Office: (815)722-3454

Zend Server for IBM i Beta avilable at
http://www.zend.com/en/products/server/zend-server-5-new-ibmi



-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Timothy P Clark
Sent: Monday, January 04, 2010 2:26 PM
To: web400@xxxxxxxxxxxx
Subject: Re: [WEB400] MySQL IBMDB2I Storage Engine - Where
isha_ibmdb2i.soplugin ?

Hi Mike,

For the most reliable answer, you'll want to check with the PASE guys,
since it really comes down to details of the PASE runtime. Here's my
take,
though.

The 32-bit build has a smaller memory footprint and may therefore give
better performance on a system where main-store is constrained. Prior to

IBM i 6.1, there was an additional performance advantage provided by
32-bit apps; but my understanding is that in 6.1 and later, 64-bit has
caught up to 32-bit. The primary advantage of a 64-bit binary is that
the
virtually unlimited address space means that much larger data sets can
be
used.

Theoretically, then, for most shops with small or medium-sized data sets

and a reasonable number of concurrent users, there shouldn't be much
practical difference between the 32-bit and 64-bit builds. However! As
it
so happens, I was doing some performance comparisons on 32-bit vs 64-bit

builds of MySQL several weeks ago (5.1.41, I believe). My own very
limited
and *very informal* testing indicated that (all else being equal) the
64-bit build ran measurably faster than the 32-bit build. This was a
surprise to me. I don't know if MySQL uses different optimization
settings
for the different builds or why this would be the case. I would suggest
that users concerned about performance download both binaries and do
some
basic comparisons themselves. Since multiple servers can be installed
side-by-side and can point to the same data set, this is relatively easy

to do.

Did you say 50 words or 500 words...?

Tim


Tim,

Thank you for the follow up.

I am curious if there is a significant difference in performance,
power,
function of the 64-bit version over the 32-bit version. My gut would
say yes but my head is saying "why should I care unless I am using a
lot
of data and more memory addresses, etc." Might there be a small
advantage in running the 32-bit for smaller installations with less
data
requirements, etc.

In 50 words or less please :-)

Regards,

Mike

mike.p@xxxxxxxx Cell: (408)679-1011 Office: (815)722-3454

Zend Server for IBM i Beta avilable at
http://www.zend.com/en/products/server/zend-server-5-new-ibmi

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.