I see that, but this is a read-only application for most users. I
could create a local copy in /tmp, but for most jobs, the number
of queries will be small-it's just certain cases where the number
of queries is really large (in this particular case, I was querying
more data than I realized).
I think, in this case, it really is just response times due to network
overhead (and general NFS sluggishness) which are causing
it to time out. If I could change that timeout value, I really think
it would solve the problem. Looking at the code, I can break one
really big query into pieces and very likely eliminate the problem,
but I really hate to add complexity if there is an easier way to do it.
Thanks!
eric
> Date: Tue, 12 May 2009 11:09:29 -0700
> From: [email protected]
> To: [email protected]
> Subject: Re: [SOCI-users] NFS, timeouts and SQLITE3
>
>
> Generally, You should neved do things like that, this is very
> bad idea to put Sqlite DB on NFS.
>
> http://www.sqlite.org/faq.html#q5
>
> Artyom
>
>
> > Hi All,
> >
> > I have an SQLITE3 database that is generally located on a
> > mounted share, which occasionally times out. If I copy the
> > database to a local disk, it runs fine-so, I'm guessing
> > that the NFS share is slowing things down sufficiently to
> > cause SQLITE3's default timeout to be insufficient.
> >
> > Is there a way to change that timeout parameter
> > ('timeout') from soci?
> >
>
>
>
>
>
> ------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> Soci-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/soci-users
_________________________________________________________________
Insert movie times and more without leaving Hotmail®.
http://windowslive.com/Tutorial/Hotmail/QuickAdd?ocid=TXT_TAGLM_WL_HM_Tutorial_QuickAdd1_052009------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image
processing features enabled. http://p.sf.net/sfu/kodak-com
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
