Re: Joins with WebObjects
Re: Joins with WebObjects
- Subject: Re: Joins with WebObjects
- From: Arturo Pérez <email@hidden>
- Date: Sat, 19 Mar 2005 13:08:43 -0500
Just to make sure, you're just timing the SQL, right? 'Cause in EOF
you do normally have object creation overhead...
That is, you go to the equivalent of SQLPLUS and type in what EOF
generates and what you want.
-arturo
On Mar 19, 2005, at 12:56 PM, Guido Neitzer wrote:
"Guido Neitzer" <email@hidden> wrote:
I have changed the NAMING for the join table and the columns there to
have a
better understanding of the SQL. I have changed NOTHING else.
Recreated the
db, imported the data. Everything the same than before only the names
of one
table and the columns there have changed.
Now it's fast. I don't understand that. Absolutely not. F***. I hate
this
situation ... :-(
Me again.
I tested more and more and also it IS definitely faster than before,
it's
not nearly as fast as an explicit join. It's currently about 5 times
faster
than before (700ms) but the explicit join takes only about 30ms. This
is 20
(!!) times faster.
I think this should go now to the Frontbase list ...
Thanks for your patience.
cug
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
email@hidden
This email sent to email@hidden
_______________________________________________
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