X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C4EDF32A096 for ; Tue, 19 Oct 2004 20:55:11 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26815-01 for ; Tue, 19 Oct 2004 19:55:04 +0000 (GMT) Received: from mproxy.gmail.com (rproxy.gmail.com [64.233.170.192]) by svr1.postgresql.org (Postfix) with ESMTP id 71C5932A084 for ; Tue, 19 Oct 2004 20:55:04 +0100 (BST) Received: by mproxy.gmail.com with SMTP id 73so375340rnk for ; Tue, 19 Oct 2004 12:55:04 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=LTXl/v2hYcx/LR6tVuX4NrgsLuM1QEcpxnR7TeKGP+ylldNzzlkUXOI1PFrGHd0J+BExNbZqWbm2IxADaw+ZY7B2YpXn1hhntu9F+P9N5kIFwf63YBTozYm0cPQVkqpOZEDesbi7PzocR4wcYxE5Y/ZWoSehD2bHS7cezNr8WtE Received: by 10.38.152.19 with SMTP id z19mr2147997rnd; Tue, 19 Oct 2004 12:55:04 -0700 (PDT) Received: by 10.38.165.32 with HTTP; Tue, 19 Oct 2004 12:55:04 -0700 (PDT) Message-ID: <27c475ec04101912556af1d77e@mail.gmail.com> Date: Tue, 19 Oct 2004 15:55:04 -0400 From: Matt Nuzum Reply-To: matt@followers.net To: jdunn@autorevenue.com Subject: Re: Speeding up this function Cc: Postgresql Performance In-Reply-To: <008e01c4b614$c86aa550$4f01a8c0@jeremydunn> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <27c475ec04101912351c451e8@mail.gmail.com> <008e01c4b614$c86aa550$4f01a8c0@jeremydunn> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/285 X-Sequence-Number: 8761 On Tue, 19 Oct 2004 15:49:45 -0400, Jeremy Dunn 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 > > > > > 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/