Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

Wed, Sep 19 2007 12:22 PM	Permanent Link
"Jose Eduardo Helminsky"	Tim I have a huge table (1.5Gb) with almost 8M records. I´ve made a test with DBSYS applying the following SQL statement: update hlan set sal=0,san=0 Both fields "sal" and "san" are not indexed and does not belong to any index and are BCD fields. After some period the app fires a write lock error (#10227). There is no transaction involved and I copy this table to another machine and repeat the process with the same problem (to isolate hardware problems). I have already repaired the table and the problem still happen. Scenario Windows XP (1Gb RAM/100Gb HD): Without network Local DB access DBISAM 4.22 Build 4 Eduardo
Wed, Sep 19 2007 1:32 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Eduardo, << Both fields "sal" and "san" are not indexed and does not belong to any index and are BCD fields. After some period the app fires a write lock error (#10227). There is no transaction involved and I copy this table to another machine and repeat the process with the same problem (to isolate hardware problems). I have already repaired the table and the problem still happen. >> It could be one of these issues: http://www.elevatesoft.com/scripts/incident.dll?action=viewrep&category=dbisam&release=4.22&type=f&incident=2156 http://www.elevatesoft.com/scripts/incident.dll?action=viewrep&category=dbisam&release=4.22&type=f&incident=2142 http://www.elevatesoft.com/scripts/incident.dll?action=viewrep&category=dbisam&release=4.22&type=f&incident=2141 -- Tim Young Elevate Software www.elevatesoft.com
Wed, Sep 19 2007 5:44 PM	Permanent Link
"Jose Eduardo Helminsky"	Tim I have to upgrade my DBISAM to last v4 build, but I have to ask you how stable is the last version ? Is there any pending issues ? Will be a next v4 build soon ? Eduardo
Thu, Sep 20 2007 2:05 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Eduardo, << I have to upgrade my DBISAM to last v4 build, but I have to ask you how stable is the last version ? Is there any pending issues ? Will be a next v4 build soon ? >> It looks like I will be doing a new build in the next day or so, but the only really notable issue existing with 4.25 Build 6 is the remote encryption/RemoteReadSize issue: http://www.elevatesoft.com/scripts/newsgrp.dll?action=openmsg&group=12&msg=6442&page=1#msg6442 -- Tim Young Elevate Software www.elevatesoft.com