Subject Re: Query Optimisation problems on different platforms
Author phil_hhn
--- In firebird-support@yahoogroups.com, Ali Gökçen <ali_gokcen@...>
wrote:
>
> time_lord,
>
> are you sure they are exactly same release?(v1.5.1)
> how can you be so sure about different optimisation,
> did you compare plans for both, could you show us them?
>
> Different HW and SW platforms may run in different speeds.
> even two same machines will work in different speeds.
> disc organisation and RAM organisation and usage can not be same.
> Computer oscilators may be work at fixed frequence(except mobiles)
> but computers don't work at fixed speed.
> There are alot of components and HW IRQs arised asynchronously...
>
> Only complaint can not help you or anybody,
> you need to show us your table&index structers, your query and its
> plan text created by FB.
>
> Regards.
>
> Ali

Hi, no I didn't say they were exactly the same versions, but that does
not appear to be too relevant. We have 1.5.2 on Windows; on the Mac we
started with 1.5.1, and tried 1.5.3 also, but that exhibited the same
problems. [We've compiled Mac 1.5.3 from source since there isn't an
'official' 1.5.3 installer on the firebird site.]

Please don't get the wrong idea, I really like Firebird and much
prefer it to SQL Server when writing SQL. However we do have this
problem, so I was after feedback as to whether others were aware of
differences in optimisation on the Mac.
I don't think the difference is in a few clock cycles.... much more
significant is the poor file system speed on OSX, which has
significantly improved in 10.4.x.

Thanks