> Huh? I'm sorry, Was my question related to money?

Not at all.

> so Money talks, right?

Sometimes, even in an OpenSource project, although it shouldn't be the
general case. The Firebird project tries to be backward-compatible and
regression free as possible, all at no cost. Although you asked a
technical question, I wonder how the Firebird Foundation could attract
you as a user and your rather huge customer base to possibly join as a
sponsor? Seriously, think about what you would loose if Firebird
wouldn't be developed anymore or if you need to switch to a different
product?

I'm sorry, for being not technical. Usually I'm more productive in my
posts. It's a bit irritating that people use Firebird in such a huge
sense without joining the Firebird Foundation party, with a fraction per
installation. If you are already a member or sponsor, then please
forgive me.

From a technical POV:

- Fool the optimizer with the proposed solution
- Revert back to 2.1.3
- Open a tracker item and hope that it get investigated for the next
sub-release

HTH.



--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!

> William
>
> On Fri, Apr 1, 2011 at 2:04 PM, Thomas Steinmaurer<ts@...>wrote:
>
>>
>>
>>> Thanks for the suggestion. I'm using DISCHARGE_DATE + 0 instead. What I
>>> don't understand is why its keep changing in different versions. Its a
>>> nightmare for us to maintain the databases. I have received a numerous if
>>> calls from my customers (We have thousands customers that using Firebird)
>>> that complaints the speed issues after upgrading to v2.1.4.
>>
>> Hearing this, I wonder if you are a Firebird Foundation member/sponsor?
>>
>> Imagine you grep a particular amount per server/customer per year, you
>> could easily get in touch with the Firebird Foundation to somehow
>> sponsor particular improvements / bugfixes very easily. You possibly
>> could even get a hand on a private build.
>>
>> Sorry, but people think that everything is free beer, which in detail
>> isn't the case. Development of Firebird costs money, quite some money,
>> which people might not know, so, perhaps you could return a fraction of
>> what you save/earn by using Firebird?
>>
>> Sorry, could not resist, had a hard week. ;-)
>>
>> --
>> With regards,
>>
>> Thomas Steinmaurer
>> Upscene Productions
>> http://www.upscene.com
>> http://blog.upscene.com/thomas/
>>
>> Download LogManager Series, FB TraceManager today!
>> Continuous Database Monitoring Solutions supporting
>> Firebird, InterBase, Advantage Database, MS SQL Server
>> and NexusDB!
>>
>>
>>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>
>