• 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
Joins with WebObjects
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Joins with WebObjects


  • Subject: Joins with WebObjects
  • From: Guido Neitzer <email@hidden>
  • Date: Sat, 19 Mar 2005 13:55:29 +0100

Hi.

I have a problem with creating a query from WebObjects - it's just slooooow.

The involved tables (entities) are:

- a company (d)
- a service (f)
- a n:m join table between the d and f (df)

How can I create a qualifier with WebObjects that does a real join on the
tables?

When I just build some qualifiers with and tie them together with an
EOAndQualifier, the select takes about 3 to 4 seconds. When I use "handmade"
SQL to join d and df on primary key and foreign key it takes about 0.11 sek.
to return the same result.

Here's what I mean. WebObjects does something similar to this (I have made
experiments with the selects in FrontBaseManager, here is only the
"excerpt"):

select d.plz, d.nachname, d.vorname, f."name" from
    DGA_DIENSTLEISTER d, DGA_DIENSTLEISTER_FACHRICHTUNG f,
    DGA_DIENSTLEISTER_ZU_FACHRICHTUNG df
where
    ((f."name" like 'Physiotherapeuten') and
    (d.plz like '45257' and d.aktiv = 1)) and
    (d.id = df.id2 and f.id = df.id1);

This takes up to 4 seconds.

If I do this:

select d.plz, d.nachname, d.vorname, f."name" from
    DGA_DIENSTLEISTER d join DGA_DIENSTLEISTER_ZU_FACHRICHTUNG z
    on d.id = z.id2,
    DGA_DIENSTLEISTER_FACHRICHTUNG f
where
    ((f."name" like 'Physiotherapeuten') and
    (d.plz like '45257' and d.aktiv = 1)) ;

it takes about 0.11 seconds.

Is there a way to tell WebObjects how to create a "better" query?

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

  • Follow-Ups:
    • Re: Joins with WebObjects
      • From: Geoff Hopson <email@hidden>
    • Re: Joins with WebObjects
      • From: email@hidden
  • Prev by Date: Re: WOFileUpload woes (No form data left)? [SOLVED]
  • Next by Date: Re: Joins with WebObjects
  • Previous by thread: Re: WOFileUpload woes (No form data left)? [SOLVED]
  • Next by thread: Re: Joins with WebObjects
  • Index(es):
    • Date
    • Thread