> You should use these pragmas too : > > PRAGMA temp_store = MEMORY; > PRAGMA read_uncommited = TRUE;
I'll look in to those too. Thanks. > If not, a big select with a big sort could try to use temporal files > on your nfs server. As you aren't doing any write, no need to wait > for write locking. > > If you need cache being persistent between process on the same > server, you can build a ram disk, write the db there and use it from > any process. This way you read the db only once from nfs. Even > better, you can shutdown nfs because a simple ftp/http server and > wget/fetch can do what you want, serve/receive read only files. I *could*, but I shouldn't have to ;) It would make the whole execution chain/data flow more complicated than it needs to be too! Jim > > Regards, > > > > Jim Vanns > > > > -- > > Jim Vanns > > Senior Software Developer > > Framestore > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > --- --- > Eduardo Morras <emorr...@yahoo.es> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Jim Vanns Senior Software Developer Framestore _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
