RE: [sqlite] Second Btree Transaction stuck at commit

2006-08-21 Thread William Chan
eClean()??? -Original Message- From: William Chan [mailto:[EMAIL PROTECTED] Sent: Friday, August 11, 2006 12:11 AM To: 'William Chan'; 'sqlite-users@sqlite.org' Subject: RE: [sqlite] Second Btree Transaction stuck at commit Hi Richard, I found out I did not solve the problem yesterday because the

RE: [sqlite] Second Btree Transaction stuck at commit

2006-08-10 Thread William Chan
From: William Chan [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 09, 2006 7:25 PM To: 'sqlite-users@sqlite.org' Subject: RE: [sqlite] Second Btree Transaction stuck at commit Thanks Richard. I need btree indexing in a commercial project and looks like everybody is charging fee... and it wo

RE: [sqlite] Second Btree Transaction stuck at commit

2006-08-09 Thread William Chan
. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 09, 2006 7:09 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Second Btree Transaction stuck at commit "William Chan" <[EMAIL PROTECTED]> wrote: > Hi Guys, > > I think I figu

Re: [sqlite] Second Btree Transaction stuck at commit

2006-08-09 Thread drh
"William Chan" <[EMAIL PROTECTED]> wrote: > Hi Guys, > > I think I figure out my problem. Looks like I need to close the cursor and > create a new cursor between the two Btree transactions. Then the second > btree commit will go thru. Can someone explain to me why? Thanks. > Before you go

RE: [sqlite] Second Btree Transaction stuck at commit

2006-08-09 Thread William Chan
Hi Guys, I think I figure out my problem. Looks like I need to close the cursor and create a new cursor between the two Btree transactions. Then the second btree commit will go thru. Can someone explain to me why? Thanks. Regards, William -Original Message- From: William Chan