-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Ralf Junker wrote: > I need to create a huge database (about 6 GB, more than 6 mio records, blobs, > and FTS text) in as little time as possible. Since memory is the key to > speed, I try to use as much memory as is available. However, there is the > danger of running out of memory. This is where memory usage control comes > into play. I can see there are two options:
Are you using a 32 bit or 64 bit process. Also is there a requirement to create the database in the filesystem? If not you could ensure your swap is sufficiently large (I use a mininmum of 16GB on my machines :-) and create in a tmpfs filesystem, and then copy the database to persistent storage when you are done. You also didn't list turning off synchronous etc while creating the database and turning it back on when done. I am curious why you think memory is the bottleneck anyway! Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFIArulmOOfHg372QQRAvNrAKDM5b4Tvf+QWfp2tWk6fYIuILE4xgCgj7tQ QatXpI5lnZEw6uPjDtnBGu0= =toXf -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
