UniDAC MySQL - OsX vs Win32 - Speed Difference Why?

imsims · Post by **imsims** » Wed 21 Mar 2012 14:08

Hi!

with my great surprise, i notice this:

Executing SAME query that returns about 100.000 recors

Query Time in MacOsx 4 seconds
Query Time in Win32 7 seconds

Have You Idea Why?

and my MacOSx is a Vmware MAchine !!

AndreyZ · Post by **AndreyZ** » Thu 22 Mar 2012 12:33

Hello,

Please answer the following questions:
- do you use visual components in your test application?
- did you change UniDAC default options before testing?
- did you change UniDAC options for each platform?

imsims · Post by **imsims** » Fri 23 Mar 2012 01:39

the code is exact the same except for my correction for
support compression in MAcOS

{$IFDEF MACOS}
self.UniConnection1.SpecificOptions.Values['Compress']:='True';
MemUtils.CompressProc:[email protected];
MemUtils.UncompressProc:[email protected];
{$ENDIF MACOS}
{$IFDEF MSWINDOWS}
self.UniConnection1.SpecificOptions.Values['Compress']:='True';
{$ENDIF MSWINDOWS}

better zlib under macosx?

AndreyZ · Post by **AndreyZ** » Fri 23 Mar 2012 11:32

The point is that UniDAC Trial Edition has different trial restrictions for Windows and MacOS. Under Windows we show the message about usage of the UniDAC Trial version, and under MacOS we limit the number of the retrieved columns to 6. It seems that the difference in speed is caused by this. Also, we didn't check zlib performance, but we think it unlikely influences the speed of our components under different OSs.