Re: Joins with WebObjects
Re: Joins with WebObjects
- Subject: Re: Joins with WebObjects
- From: Guido Neitzer <email@hidden>
- Date: Sat, 19 Mar 2005 21:26:13 +0100
"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
_______________________________________________
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