2012/1/2 Baruch Burstein <bmburst...@gmail.com>: > My resources are a bunch of sound and image files, level data files, > script files and other game data stuff. Instead of distributing my game > with about 20-30 small (some very small) files, I thought I would roll all > the files into some kind of archive. I started to roll my own format, when > it occurred to me that sqlite may be well suited for this. Which brought me > to wonder if storing 5-10 tables with some of them having <500 bytes of > data may be very inefficient. I don't want to substitute a 20K file for my > <10K of files. I know this is not a lot, but it still bothers me, like what > when I have a game with 500M of files? (you never know, it may happen!). No > searching is needed (except once for the key to load a resource)
Such data in SQLite take up less space than in the file system. You can save data in one table, see above. -- Kit _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users