• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Joins with WebObjects
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

  • Prev by Date: NSForwardException in WOMailDelivery
  • Next by Date: Re: XHTML WOForm?
  • Previous by thread: Re: Joins with WebObjects
  • Next by thread: eomodeld import problems
  • Index(es):
    • Date
    • Thread