| From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
|---|---|
| To: | Naz Gassiep <naz(at)mira(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Query optimisation |
| Date: | 2008-04-07 04:43:38 |
| Message-ID: | 47F9A67A.9090903@postnewspapers.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Naz Gassiep wrote:
> JOIN files imageid_file ON (images.imageid =
> imageid_file.fileid)
> JOIN files size120_file ON (images.size120 =
> size120_file.fileid)
> JOIN files size240_file ON (images.size240 =
> size240_file.fileid)
> JOIN files size420_file ON (images.size420 =
> size420_file.fileid)
> JOIN files size600_file ON (images.size600 =
> size600_file.fileid)
> JOIN files size800_file ON (images.size800 =
> size800_file.fileid)
> JOIN files size1024_file ON (images.size1024 =
> size1024_file.fileid)
> JOIN files size130sq_file ON (images.size130sq =
> size130sq_file.fileid)
> JOIN files size240sq_file ON (images.size240sq =
> size240sq_file.fileid)
> JOIN files size420sq_file ON (images.size420sq =
> size420sq_file.fileid)
> JOIN images_sites ON (images_sites.imageid =
> images.imageid)
That's a whole lot of joins.
Do all those tables have the same fields? Can you unify them into one
table with an additional field like "imagesize" and use an appropriate
WHERE clause when looking up the table?
--
Craig Ringer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-04-07 04:53:06 | Re: Query optimisation |
| Previous Message | Tom Lane | 2008-04-07 04:36:48 | Re: Removing Context messages |