Page 1 of 1
UniDAC MySQL - OsX vs Win32 - Speed Difference Why?
Posted: Wed 21 Mar 2012 14:08
by imsims
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 !!
Posted: Thu 22 Mar 2012 12:33
by AndreyZ
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?
Posted: Fri 23 Mar 2012 01:39
by imsims
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?
Posted: Fri 23 Mar 2012 11:32
by AndreyZ
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.