Re: [sqlite] SQLite over NFS

2010-03-29 Thread Nicolas Williams
On Mon, Mar 29, 2010 at 07:50:38AM -0700, Kumar, Abhinav wrote: > I am using SQLite version 3.5.9. My db sizes are 50-100 Gb. My DB is a > typical star schema. I am seeing an order of magnitude more time to do > a simple select query when doing over NFS (30-60 seconds) as compared > to local disk

Re: [sqlite] SQLite over NFS

2010-03-29 Thread D. Richard Hipp
On Mar 29, 2010, at 10:50 AM, Kumar, Abhinav wrote: > Hi, > > I am using SQLite version 3.5.9. My db sizes are 50-100 Gb. My DB is > a typical star schema. I am seeing an order of magnitude more time > to do a simple select query when doing over NFS (30-60 seconds) as > compared to local

[sqlite] SQLite over NFS

2010-03-29 Thread Kumar, Abhinav
Hi, I am using SQLite version 3.5.9. My db sizes are 50-100 Gb. My DB is a typical star schema. I am seeing an order of magnitude more time to do a simple select query when doing over NFS (30-60 seconds) as compared to local disk (2 seconds). Is there any way to optimize this ? Thanks,