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 as 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 an update or a locked update statement. Another way would be to create a table that was a "counter" table that you inserted into versus updating. The "report" would then be along the lines of "select count(page_id) as 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
