Hi Ken,
Actually there are many queries that are impossible to do with the set of tools
that Apple gives us. We *can* write special qualifiers but it takes time and is
a bit daunting to get up to speed with.
A surprisingly large set of these “unsolvable” problems can be overcome with a
custom “Exists” qualifier which is what I’ll present at WOWODC.
But you are right on the money, “performance” is often a cop-out for “I don’t
understand” how to do it a better way so I roll up my sleeves and write it in
straight SQL. I mean, heck, EOF lets us pass hints down to SQL if we want to.
AARON ROSENZWEIG / Chat 'n Bike
e: aa...@chatnbike.com t: (301) 956-2319
On Mar 25, 2014, at 7:44 AM, Ken Anderson <kenli...@anderhome.com> wrote:
> Oscar,
>
> As an aside, I suggest you use Wonder’s features to implement the port, so
> you’re not stuck again with raw SQL. I would also bet that raw SQL has
> nothing to do with performance, but more with either:
>
> 1. A very complex query that cannot be translated into qualifiers (rare)
> 2. A developer that didn’t understand what was possible
>
> Fix it now, so you don’t have to fix it later! I learned so much good stuff
> about ERXKey lately!
>
> Ken
>
> On Mar 24, 2014, at 11:28 PM, Chuck Hill <ch...@global-village.net> wrote:
>
>> Hi Oscar,
>>
>>
>> On 2014-03-24, 5:54 PM, "Oscar González" wrote:
>>
>> Hi all,
>> I'm migrating a few projects from Oracle to Postgresql, there are a lot
>> straight RawRow for performance.
>>
>> Raw rows or raw SQL? Most raw row stuff can take a qualifier which removes
>> the need for raw (custom) SQL. You are using Wonder, right?
>>
>>
>> Now I'm facing the problem of changing every incompatibility like nvl for
>> coalesce for example.
>> 1. I will like to know the right way of doing a RawRow to use the JdbcPlugin
>> for better cross databases
>>
>> There might be some stuff in JDBCPlugin or in the SQLHelper family to make
>> this easier, but it might be more trouble than it is worth unless you plan
>> on migrating the projects again.
>>
>>
>> 2. For my own problem is there any workaround instead of doing it by the
>> long way.
>>
>> I think you might be stuck with it. Oracle is known for doing things its
>> own way.
>>
>>
>> Chuck
>>
>>
>>
>> Appreciate any help
>>
>> Saludos,
>>
>> Óscar González Pérez
>> TECH un AGRO S.A
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
>> Help/Unsubscribe/Update your Subscription:
>> https://lists.apple.com/mailman/options/webobjects-dev/kenlists%40anderhome.com
>>
>> This email sent to kenli...@anderhome.com
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/aaron%40chatnbike.com
>
> This email sent to aa...@chatnbike.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
