Re: Joins with WebObjects
Re: Joins with WebObjects
- Subject: Re: Joins with WebObjects
- From: Guido Neitzer <email@hidden>
- Date: Sun, 20 Mar 2005 10:44:26 +0100
It's mostly generated - I have stripped the first part (what to be fetched)
and formatted the rest.
Why?
cug
"Arturo Pérez" <email@hidden> wrote:
> Is that the SQL generated by EOF or your own?
>
> On Mar 19, 2005, at 3:26 PM, Guido Neitzer wrote:
>
>> "Arturo Pérez" <email@hidden> wrote:
>>
>>> Just to make sure, you're just timing the SQL, right? 'Cause in EOF
>>> you do normally have object creation overhead...
>>
>> Yes, I do.
>>
>> I have tried many things and received pretty good response times -
>> only when
>> I add the qualifier for the to many relationship the select times
>> explode.
>>
>> Also I have tried the same with PostgreSQL and get the following
>> construct
>> (a little bit cleaned up):
>>
>> SELECT t0.*
>>
>> FROM DGA_DIENSTLEISTER t0
>> INNER JOIN DGA_DIENSTLEISTER_ZU_FACHRICHTUNG T1 ON t0.ID = T1.ID2
>> INNER JOIN DGA_DIENSTLEISTER_FACHRICHTUNG T2 ON T1.ID1 = T2.ID
>>
>> WHERE (t
>> 0.KATEGORIE_FID = ?::int8 AND t0.PLZ like ?::varchar(256) ESCAPE
>> '|' AND t0.AKTIV = ?::int2 AND T2.NAME = ?::varchar(256))
>>
>> ORDER BY t0.IST_TEILNEHMER DESC, t0.NACHNAME ASC, t0.VORNAME ASC,
>> t0.FIRMA
>> ASC
>>
>>
>> I get select times of 280ms on my dual G5 1.8GHz and about 390ms on my
>> Powerbook. Frontbase is currently at about 700ms with the select
>> generated
>> by WO.
>>
>> cug
>>
>>
>> --
>> Cocoa Seminar with Aaron Hillegass in Germany
>> http://www.dreamteam-events.com
>>
>>
>>
>
--
Cocoa Seminar with Aaron Hillegass in Germany
http://www.dreamteam-events.com
_______________________________________________
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