Simon: no, AFS=Andrew File System :). Both my servers run Ubuntu (64-bit). In case of the 12 Gb RAM machine, everything is done locally. On the 32 Gb machine, I'm afraid I can't do that. And in fact I've been using the command-line tool all along.
On Thu, Jun 23, 2011 at 2:45 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 23 Jun 2011, at 7:20pm, Rense Corten wrote: > >> As to RAM: I'm trying this on two different machines, one with 12 Gb >> and one with 32 Gb RAM. I won't be able to get more in the near >> future. Something that might be relevant is that the case of the 32Gb >> machine, the database is on an AFS. > > Wait … AFS == Apple File Service ? You're doing this on Macintoshes > accessing storage over a network ? Okay, then the cause of your speed > problems is the network. Please try creating the INDEX locally on the > server. You don't need to write a program to do this, you can use the > command-line tool which you'll find at > > /usr/bin/sqlite3 > > Simon. > _______________________________________________ > 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