3 ms·
My assumption was that the system had finite ram available, whether that's serialized in a database or read directly into the program.
by dev_dull 7y ago
My assumption was that the system had finite ram available, whether that's serialized in a database or read directly into the program.
- gwbas1c 7y agoSo? Typically "database" implies a product like SQLite or Postgres. These handle many multiples of RAM size. In-memory databases are a thing, but that's a very specialized use case.
- dfox 7y agoSomewhat surprising fact about most PostgreSQL deployments is that most of the frequently accessed tuples will fit into RAM and it handles this usecase really well (to the extent that people who don’t know any better do not see any issue with LIKE ‘%whatewer%’ over 100M tuple table, it just takes 1.5s, so what...)
- PhearTheCeal 7y agoPretty much all SQL DBs support pagination, and many libraries that abstract the DB away hide this as an iterator.