Re: Query performance question

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