On Thu, 10 Aug 2017, Clemens Ladisch wrote:
x wrote:
I’m thinking about this more from the gain in speed rather than saving space.
Database performance is usually limited by I/O, i.e., you gain speed by
saving space.
To be clear, database performance is usually limited by the number of
I/O operations possible within a given amount of time (IOPS) rather
than the bandwidth (bytes/second) available.
If the database is small enough to fit in the OS filesystem cache,
then hardly any I/O operations to underlying store will be needed to
satisfy requests.
Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer, http://www.GraphicsMagick.org/
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
