Subject | Re: Transactions in firebird (on behalf of Slavo) |
---|---|
Author | firebird_sl |
Post date | 2006-04-22T01:07:47Z |
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
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