On Sun, Dec 16, 2012 at 10:02:41PM +0200, ?a?lar Orhan wrote: > Hello again, > Thank you Simon. > The page http://www.sqlite.org/limits.html has my answer partly. In MS IIS > what gbytes bigger size of .sqlite file should significant to work on it > properly? > I mean, is there a 10-12 GB sqlite file that working properly and with any > problem?
There is only limitation on the total number of pages in the file. So, the file size is limited by SQLITE_MAX_PAGE_COUNT times PAGE_SIZE. Thus, given enough page size, say, 8 to 64 kilobytes, sqlite successfully handles files of many terabytes in size, provided underlying filesystem supports them, of course. Be prepared to wait quite a long for non-sqlite operations (copy, delete etc.) to complete on such a big files. Valentin Davydov. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
