Am 12.08.2010 12:16, schrieb Martin.Engelschalk: > > 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. >> > Hello Thomas, > > 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. > Hello Martin,
that sounds like a good idea. Do you use it to have enough space for later operations or because you want to speed up the inserts? How big is the space you reserve by this and how much faster is it? I presume, you have to allocate quite big BLOBs. Best regards, Thomas _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
