Re: Query performance question

As the tables are linked by

WHERE hits.referrer_id =referrer.id

just adding to select referrer.url should display url
I did not see right away that referrer.id was unique. Hence the
suggestion to add a
unique ID for the tuples.

Vijay

Lukas Ertl wrote:

> On Thu, 29 Mar 2001, Vijay Deval wrote:
>
> > URL is a very large field.  If an extra field is created which gives
a
> > neumeric id to the url, run the query on the number, and then get
the desired
> > output
>
> I have to admit, that I quite don't understand what you want me to do
> here... I already have that numeric id:
>
> > > httplog=# \d referrer
> > >           Table "referrer"
> > >  Attribute |     Type     | Modifier
> > > -----------+--------------+----------
> > >  id        | integer      |
> > >  url       | varchar(300) |
> > > Index: referrer_pkey
>
> If I say:
>
> SELECT count(*), referrer.id FROM hits, referrer WHERE referrer.id =
> referrer_id GROUP BY referrer.id ORDER BY count DESC LIMIT 10;
>
> it is really fast and I get the IDs of the referrer-urls but how would
I
> get the URLs then?
>
> regards,
> le
>
> --
> Lukas Ertl                          eMail: l.ertl@univie.ac.at
> WWW-Redaktion                       Tel.:  (+43 1) 4277-14073
> Zentraler Informatikdienst (ZID)    Fax.:  (+43 1) 4277-9140
> der Universität Wien