I can see where he is coming from. By reserving the appropriate number of pages up front the import does not have to wait for disk IO or CPU cycles if it runs out of pages.
------Original Message------ From: Pavel Ivanov Sender: sqlite-users-boun...@sqlite.org To: General Discussion of SQLite Database ReplyTo: General Discussion of SQLite Database Subject: Re: [sqlite] Reserve database pages Sent: Aug 12, 2010 06:20 > 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. Why do you think that this kind of function will speed up your import? Pavel On Thu, Aug 12, 2010 at 6:08 AM, TeDe <tede_1...@gmx.de> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ** Sent from my mobile device with the tiny keys ** Timothy A. Sawyer, CISSP Managing Director MBD Consulting, LLC 55 Madison Av., Suite 400 Morristown, NJ 07960 Phone: (973) 285-3261 | Fax: (973) 538-0503 Web: http://www.mybowlingdiary.com Email: tsaw...@mybowlingdiary.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
