Oddbean new post about | logout
 nostr:npub1slp5q3n9nyjn3p28hnxmvj5x82w6yw03cvplvkjdrnnuqqw4et3ste4xfq nostr:npub176lt3pm7dxyrsrxnpt0u2vquy6pwue20lcefjl32q5j9rgg27xrqh5s4md [CursorWindow](https://developer.android.com/reference/android/database/CursorWindow) just buffers the rows in memory, so it's still slow whenever you move the window. This means it has to read the data from the storage. In this aspect the memory usage is similar to preloading, except in the old days we ran the IO operation in the main thread, which was causing laggy experience for users, but now we should have learned our lessons.