10 ms·
Agree. In my case, I went from Excel stare'n'compare to MS Access and finally mySQL for several years. mySQL worked great for my lil piece of company business
by wistlo 4y ago
Agree. In my case, I went from Excel stare'n'compare to MS Access and finally mySQL for several years.
mySQL worked great for my lil piece of company business involving a few million records. But then I volunteered to do some analysis with files an order or two of magnitude larger (10 mlllion-100 million). mySQL started coughing up with memory errors. Uh oh. Embarrassing.
I should mention that I'm doing all this on a Windows desktop, as that's what is installed and locked down on the machines they give me.
Enter postGRES. No matter what I throw at it, it gets to end of the queries without errors—in Windows, no less. With an nVME and 32 GB of ram, I can run a complex report on 70M records in seconds. Loading and indexing takes about 15 min.
mySQL was very very good to me for a long time, but for the really big stuff I'm sticking with PostGRES.