We are trying to determine how BLOB type and page size impact performance. I have a few questions related to that:
1. Does BLOB type field cause any performance issues compared to using TEXT when doing inserts/updates. In other words, if they use the same number of bytes, would there be any difference in performance? 2. When you store multiple tables, does each table get stored on a page by itself, so the larger the page size, the more likely you would see contiguous items for a table? 3. How does the sqlite page size correlate with the file system block size? In other words, if sqlite uses a page size of 1K and the file system uses a block size of 4K, would you still end up writing 4K even if you changed only 1K? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
