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

--- In firebird-php@yahoogroups.com, Lester Caine <lester@...> wrote:
>
> masotti wrote:
> >>> Default transactions are IBASE_WRITE | IBASE_CONCURRENCY | IBASE_WAIT,
> >>> so you need to alter default transaction in client library to IBASE_READ
> >>> | IBASE_COMMITED | IBASE_REC_VERSION | IBASE_NO_WAIT.
> >>
> >> ADOdb default is IBASE_WAIT | IBASE_REC_VERSION | IBASE_COMMITTED
> >> Should I need to add IBASE_READ to that, and why not IBASE_WAIT there ?
> >
> > Sorry : I missed you're using AdoDb. If most of your transactions are
> > read-only, why not?
> > I'm not sure, I'll need to refresh some theory on transactions, but if
> > you are reading only, what are WAITing for?
> > I don't remember for sure if there is a meaning for a read-only + wait
> > connection or they are not compatible parameters.
>
> There is currently no differentiation in bitweaver between 'readers' and
> 'editors', but every 'read' of a page will create a write of some sort anyway.
>
> The 'insert per page read' is actually making more sense now I think about it.
> This area of the code has changed little from Tikiwiki/Tikipro days, and
> extending the 'hits' table to include a user_id or ip address of anonymous
> readers does make a lot of sense nowadays. I might even be able to track the
> search bots activity ;)
>
> --
> 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
>