Redis Re-Implemented with SQLite

Re:Redis Re-Implemented with SQLite by out_of_protocol on Monday April 15, 2024 @06:19AM (#40038614)

Well, you can't do O(1) part for most commands :) redis can do a lot of stuff at near constant (and superfast) speed. Databases do become slower when your dataset is big

[ Parent | on HN ]

Re:Redis Re-Implemented with SQLite by beepbooptheory on Monday April 15, 2024 @07:12AM (#40038991)

But if its that big, how are you fitting it in your RAM with Redis anyway?

[ Parent | on HN ]

Re:Redis Re-Implemented with SQLite by out_of_protocol on Monday April 15, 2024 @08:47AM (#40039883)

You can buy servers with 1TB RAM for reasonable price. Also, you don't need to go this big, even moderate-sized tables are slow. Indexes are usually log(n) at best (and eating more RAM anyway, you can get said log(n) if all index data is in memory, and at this point regular sql db eating more ram than redis), and insert time is slowing down since you need to update index as well (and maybe reorg stuff around)

[ Parent | on HN ]