Subject Re: Transactions in firebird (on behalf of Slavo)
Author firebird_sl
Hi,
at first, thanks to all for their help:)
I tried to remove IBASE_NO_REC_VERSION, now I'm periodicly checking
php log for any errors:)

To Adam's message:
unfortunately, I can't use this method of inserting visits, because I
need these values (impressions) in each visit, I'll explain:

Table VISITS (ID,IP,DATE,RANK,NUM_VISIT,NUM_CLICK)

where RANK is computed on each site's visit, as
RANK=NUM_CLICK/NUM_VISIT (aka CLICKRATE)

where NUM_VISIT is number of impressions and NUM_CLICK is number of
clicks on banner on the site.

I use this RANK to find page with best CLICKRATE, for internal
processing:)

So is removing of the NO_REC best solution?

Script is something like this:)

BEGIN
SELECT ID FROM VISITS ORDER BY RANK DESC;
UPDATE SITE SET NUM_VISIT=NUM_VISIT+1,RANK=NUM_CLICK/NUM_VISIT WHERE
ID=id;
END

Btw, how can I simulate deadlock?:)
Thanks a lot,
again for your replies,have a nice day,
Slavo