Re: Speeding up this function - Mailing list pgsql-performance

From Matt Nuzum
Subject Re: Speeding up this function
Date
Msg-id 27c475ec04101912556af1d77e@mail.gmail.com
Whole thread Raw
In response to Re: Speeding up this function  ("Jeremy Dunn" <jdunn@autorevenue.com>)
List pgsql-performance
On Tue, 19 Oct 2004 15:49:45 -0400, Jeremy Dunn <jdunn@autorevenue.com> wrote:
> > -----Original Message-----
> > From: pgsql-performance-owner@postgresql.org
> > [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of
> > Matt Nuzum
> > Sent: Tuesday, October 19, 2004 3:35 PM
> > To: pgsql-performance
> > Subject: [PERFORM] Speeding up this function
> >
> <snip>
<snip>
>
> This is probably a stupid question, but why are you trying to create
> sessions after the fact?  Since it appears that users of your site must
> login, why not just assign a sessionID to them at login time, and keep
> it in the URL for the duration of the session?  Then it would be easy to
> track where they've been.
>
> - Jeremy
>
>

You don't have to log in to visit the sites.  These log files are
actually for many domains.  Right now, we do logging with a web-bug
and it does handle the sessions, but it relies on javascript and we
want to track a lot more than we are now.  Plus, that code is in
JavaScript and one of our primary motiviations is to ditch MySQL
completely.

--
Matthew Nuzum        | Makers of "Elite Content Management System"
www.followers.net        | View samples of Elite CMS in action
matt@followers.net        | http://www.followers.net/portfolio/

pgsql-performance by date:

Previous
From: "Jeremy Dunn"
Date:
Subject: Re: Speeding up this function
Next
From: Mischa Sandberg
Date:
Subject: Re: Normal case or bad query plan?