| 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.
On Mar 25, 2014, at 7:44 AM, Ken Anderson < email@hidden> 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 < email@hidden> 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 (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
|