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