have a seperate table for each site, not a seperate database.
-----Original Message-----
From: James Smith [mailto:[EMAIL PROTECTED]]
Sent: 13 February 2001 14:57
To: CF-Community
Subject: Client Variable Storage
OK, here is one for you.
I have set client variables to be stored in a database (MySQL, but that is
irelevant) and have come accross a problem I had never noticed before...
The DATA field of the CGLOBAL table stores a hit count, but on a client
basis not a client/application basis. This means that if I store client
variables from two applications in the same database the hitcount is a
total.
Illustration: I visit site1 20 times, I visit site2 20 times, the hitcount
stored in the database reads 40.
This makes it practically useless as a hitcount on any site as (although it
is unlikely) if one person visits two sites on the server the data becomes
irelevant.
I can only think of two solutions to this...
1) Use a seperate database for every single site. This is a bit of overkill
and adds great complexity to the server.
2) Store the hit count seperately (as client.site1_hitcount for example).
Is there a better solution or am I going about this totally the wrong way?
--
James Smith
[EMAIL PROTECTED]
Brainbench transcript ID: 822462
http://www.brainbench.com/transcript.jsp?pid=822462
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
