Hi In order to avoid fragmentation, we use sql as a buffer: all I/O have been rewritten to use a buffer instead a file writting. The previous solution (which cause fragmentation then) was to load a DB from file, creta a :memory: db, and then copy all data and structure from file DB --> mem DB. But once released, the file DB created the fragmentation. I don' t know if there are other ideas, but at least this was ok for us :)
Mauricio Aniche a écrit : > Hey guys, > > I just ported Sqlite to my device. I want to know any feature I can turn > on/off in order to save memory! I have only 2mb of disk space, so any byte > is important! :) > > Do you guys have any tip for me? > > Thanks in advance, > Mauricio > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
