First : thank all of you guys... :) Right now, we made this (for people can be interested)
1. An update statement like: UPDATE Statistics SET Displays = Displays + 1 WHERE IDCard= #attributes.IDCard# and DisplayDate = #odbcDate# where: odbcdate: is the date of the day using this format mm/dd/yyyy (without time) This table contains the daily hits statistics. 2. Each month, a process consolidate that data into a montly table (and delete the old ones) --- I know DB (SQL Server in my case) must be able (or we must suppose that) to process tons of transactions without problems but, because of the increa sing of hits, I thought text file can be a better alternative. I hope the current mechanism is a scalable one. Thanks again, JAAV ----- Original Message ----- From: "Andrew Scott" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 22, 2002 3:36 PM Subject: RE: Hits counter at DB? (II) > Well no not really because this file gets cached by the OS, but it wou ld > have to be cflocked and this would create a performance loss! > > > -----Original Message----- > From: Steve Oliver [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 23 January 2002 1:31 AM > To: CF-Talk > Subject: RE: Hits counter at DB? (II) > > Oh, one more thing, about the text file hit counter. > > If your using a text file, your server would have to access that file on > the hard drive each time it was written to. > > That would cause serious performance loss. > > The fastest way would be through the database, adding a hit_counter > field to your rows would be less of an impact on the database size the n > if you added an entire new table that tracked each business card by > hits. > > ______________________ > steve oliver > cresco technologies, inc. > http://www.crescotech.com > > > -----Original Message----- > From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 22, 2002 8:48 AM > To: CF-Talk > Subject: RE: Hits counter at DB? (II) > > > Okay, going on that there are a couple of questions to ask in return. > What kind of data source is this running on? Is it running on a > dedicated machine or on something that is sharing resources? As far a s > the "business cards", where do they come from? Are they stored in the > database or are they static pages that are being called? > > Counters can be done any number of ways. The easiest would be to do a n > update or a locked update statement. Another way would be to create a > table that was a "counter" table that you inserted into versus updatin g. > The "report" would then be along the lines of "select count(page_id) a s > hit_count from counter where page_id = whatever" instead of "select > hit_count from counter". Another idea, a hybrid of the two I just > mentioned, would be to have a temp table that a hit would insert into > and then a second table that head totals that were calculated nightly by > a scheduled process. > > Hope these give you some food for thought. > > Hatton > > > > Our website is composed by a huge number of "business cards". We > > > want to show to our clients their "card" statistics with pretty > > > interface. > > Something > > > like: hits by day, hits in the last month, average, etc. The first > > > thing > > we > > > thought was to make an "UPDATE Counter = Counter + 1" query > > each time the > > > webuser hits each webpage. But We are thinking this can be > > dangerous cause > > > we have more than 1000 000 hits in a month and growing. > > > > > > We can't give access to a statistics software. > > > > > > May we use and text file instead? What do you recommend? > > > > > > Thanks in advance, > > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
