Re: [sqlite] SQLite db file size and NFS file locking issue

2006-05-18 Thread Jay Sprenkle
Is there any limit (besides the OS files system limit) on how big the db file size can be with SQLite? Mostly it's operating system limits. Also, is there any NFS locking issue with SQLite database? Sometimes if a client opens the files and die, do we have problems reading the file again

Re: [sqlite] SQLite db file size and NFS file locking issue

2006-05-18 Thread drh
Rajan, Vivek K [EMAIL PROTECTED] wrote: Also, is there any NFS locking issue with SQLite database? Sometimes if a client opens the files and die, do we have problems reading the file again because NFS lock for the file still exists!? Is this true? There are no locking issues within

Re: [sqlite] SQLite db file size and NFS file locking issue

2006-05-18 Thread Joe Wilson
Many servers create lock files on NFS instead of using POSIX locks due to the flakey NFS lock implementations. (Does any OS other than Solaris support NFS locks correctly???) The existance of the lock file indicates that another process has locked the main file. --- [EMAIL PROTECTED] wrote:

[sqlite] SQLite db file size and NFS file locking issue

2006-05-17 Thread Rajan, Vivek K
Hello- Is there any limit (besides the OS files system limit) on how big the db file size can be with SQLite? Also, is there any NFS locking issue with SQLite database? Sometimes if a client opens the files and die, do we have problems reading the file again because NFS lock for the file