bitweaver
Wiki
wiki Home
List Pages
wiki Books
Orphan Pages
wiki Rankings
Photos
List Galleries
Forums
Browse forums
Files
List Galleries
Categories
List Categories
Sign In
Message Boards
»
08. Support - General talk
Newest
Oldest
Threaded
5
10
20
50
100
All
Messages
Firebird specs
Post Reply
Simon Benedicic
Joined: 26 Jul 2005
Firebird specs
Posted:29 Jul 2005 (20:43 UTC)
Post Reply
Page 1 of 1
1
Post
Title
Login
If you are already registered, please enter your login credentials.
Your Name
Anonymous Post
Content Format
Tiki Wiki Syntax
Allow HTML
{quote format_guid="bbcode" comment_id="5637" user="simon"}Hi, When I gave Bitweaver more serious testrun I came to a problem regarding DEADLOCK and CONCURENT UPDATE. As you know this happend when 2 transaction try to update the same record almost at the same time (BTW: Lester has his FirebirdTiki page online and I tested it against this and it also failed). This problem shows in updating stats data and session data (this one is harder...). To solve this problem I started another transaction only for this update ... and it worked fine: File stats/stats_lib.php [code:1:6c25959c00] function add_pageview() { $dayzero = mktime(0, 0, 0, date("m"), date("d"), date("Y")); $cant = $this->getOne("select count(*) from `".BIT_DB_PREFIX."tiki_pageviews` where `day`=?",array((int)$dayzero)); $this->mDb->StartTrans(); //SB if ($cant) { $query = "update `".BIT_DB_PREFIX."tiki_pageviews` set `pageviews`=`pageviews`+1 where `day`=?"; } else{ $query = "insert into `".BIT_DB_PREFIX."tiki_pageviews`(`day`,`pageviews`) values(?,1)"; } $result = $this->query($query,array((int)$dayzero)); $this->mDb->CompleteTrans(); //SB } [/code:1:6c25959c00] Is this acceptable ? Best regards Simon{/quote}
Recent Page Changes
welcome to bitweaver.org
Bitweaver Overview
ReleaseTwo Schema Changelog 2006
PressReleaseOne
Spider's Web
Press Release Two
BitcommercePackage
InfiniBand vs Ethernet Performance
InfiniBand for Dummies
Show More…