xdenser wrote:

> another idea is to use generator for hitscount
> but you would need a separate generator for each record in LC_HITS
> you may create it in on insert trigger, drop in delete and store name of generator in the table instead of counter itself

Not practical ... there are 30,000 pages already on one site ... and growing!

But tagging WHO read pages during a day does have attractions ;)

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php