3 ms·
Oracle was a really solid choice 30 years ago, when 1Tb was an unheard-of database size. Back then, its query optimizer and a couple of strategic hints could ma
by cyberax 3y ago
Oracle was a really solid choice 30 years ago, when 1Tb was an unheard-of database size. Back then, its query optimizer and a couple of strategic hints could make a huge difference in the runtime so that a report could be produced in minutes instead of hours.
These days? You can buy a server with 1Tb of RAM, for the price of one Oracle license. Any Open Source database will work just as well as Oracle on these kinds of datasets.
And if you have bigger datasets, then they are likely not that suitable for RDBMS anyway.
- kragen 3y agoi agree that oracle was a solid choice 30 years ago, though they were already notorious for taking advantage of their customers also postgres's query optimizer has gotten a lot better i wouldn't say any open source database. it depends on your index. there are recondite but not unreasonable queries for which mariadb and sqlite still produce pathologically poor query plans which won't complete in a reasonable time even with all the data in ram. and a few years ago i had postgres totally fall over on important queries because we'd forgotten to add an index, and it took us days to figure it out because we were using amazon's outsourced postgres thing and didn't know how to admin it