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
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
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,
3 matches
Mail list logo