Guru
Joined: 05/10/2019
Location: United KingdomPosts: 8826
| Posted: 02:46pm 03 Apr 2026 |
Oh yeah, I realize that. The point I'm making is that database size isn't necessarily proportional to the amount of RAM available.
You can have blindingly fast databases if all the data is in RAM, but you have a delay while it is all read into RAM arrays or a block of RAM at the beginning and again after every write operation while the modified RAM is saved to disk or flash. The database size is severely restricted.
You can have almost as fast databases with the data stored in flash if you don't mind the wear and tear on the flash (and, preferably, force the user to do a backup after a predetermined number of write operations). The database size isn't quite so restricted as a RAM system. Using on-board flash for the database may not be a great idea due to the wear problem, even if it's fast.
It's all compromises depending on what the application is. :)