Am 12.08.2010 12:08, schrieb TeDe: > Hello, > > I want to import a big subset of data from one database to a new one. I > attach the two databases together and use > > insert into customers select * from source.customers where name LIKE 'x%' > > I can approximately calculate, how big the new database will grow. Is > there a way to tell SQLite to reserve an inital space or numer of pages > instead of letting the database file grow again and again? I'm looking > for a way to speed up the import. > > Thanks in advance, > > Thomas > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > Hello Thomas,
a short while ago there was a thread in this mailing list titled "Coping with database growth/fragmentation". Perhaps you want to search for it. AFAIK, there is no way to tell the Library to allocate a number of pages at once. I could use a function like this very well :-) I create a dummy table with a blob field and fill it with a very large empty blob. Then I drop the table. The empty pages remain behind an can the be used by the followimng inserts. Martin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users