Re: [sqlite] WAL mode and Network filesystems

2011-08-26 Thread Stephan Beal 
On Fri, Aug 26, 2011 at 4:43 PM,  wrote:

> Well, my system configuration is such that the RFS is mounted via NFS
> server. All the processes that access the DB will be on the same CPU.


Just FYI: in my very limited experience, using fcntl()-style locking on NFS
can bring slowdowns of 800% or more. It's probably not always that slow, but
it was on the couple of Linux/Solaris systems i tested on a couple years
ago.

-- 
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WAL mode and Network filesystems

2011-08-26 Thread Simon Slavin 

On 26 Aug 2011, at 3:43pm, sreekumar...@gmail.com wrote:

> Well, my system configuration is such that the RFS is mounted via NFS server. 
> All the processes that access the DB will be on the same CPU.
> 
> 
> --Original Message--
> From: Pavel Ivanov
> To: Sreekumar TP
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] WAL mode and Network filesystems
> Sent: Aug 26, 2011 20:08
> 
> http://www.sqlite.org/wal.html
> 
> Disadvantage #2:
> All processes using a database must be on the same host computer; WAL
> does not work over a network filesystem.

Note what Pavel wrote: "WAL does not work over a network filesystem."

What does 'NFS' stand for ?

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WAL mode and Network filesystems

2011-08-26 Thread sreekumar . tp 

Well, my system configuration is such that the RFS is mounted via NFS server. 
All the processes that access the DB will be on the same CPU.


--Original Message--
From: Pavel Ivanov
To: Sreekumar TP
To: General Discussion of SQLite Database
Subject: Re: [sqlite] WAL mode and Network filesystems
Sent: Aug 26, 2011 20:08

http://www.sqlite.org/wal.html

Disadvantage #2:
All processes using a database must be on the same host computer; WAL
does not work over a network filesystem.


So as long as all users of your database are on the same host it seems
that WAL will work even if file is on NFS. But then what's the point
of putting database file on NFS if all its users will be on the same
host? Local drive will work as well (even faster).


Pavel


On Fri, Aug 26, 2011 at 10:28 AM,  <sreekumar...@gmail.com> wrote:
>  I understand that WAL mode of sqlite is not supported over network file 
> systems. Does this mean that if my DB is in a filesystem mounted on a NFS 
> server will also not work in WAL mode? If so what is the bottleneck?
> Sent from BlackBerry® on Airtel
>___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>


Sent from BlackBerry® on Airtel
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WAL mode and Network filesystems

2011-08-26 Thread Pavel Ivanov 
http://www.sqlite.org/wal.html

Disadvantage #2:
All processes using a database must be on the same host computer; WAL
does not work over a network filesystem.


So as long as all users of your database are on the same host it seems
that WAL will work even if file is on NFS. But then what's the point
of putting database file on NFS if all its users will be on the same
host? Local drive will work as well (even faster).


Pavel


On Fri, Aug 26, 2011 at 10:28 AM,   wrote:
>  I understand that WAL mode of sqlite is not supported over network file 
> systems. Does this mean that if my DB is in a filesystem mounted on a NFS 
> server will also not work in WAL mode? If so what is the bottleneck?
> Sent from BlackBerry® on Airtel
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] WAL mode and Network filesystems

2011-08-26 Thread sreekumar . tp 
 I understand that WAL mode of sqlite is not supported over network file 
systems. Does this mean that if my DB is in a filesystem mounted on a NFS 
server will also not work in WAL mode? If so what is the bottleneck?
Sent from BlackBerry® on Airtel
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users