I am on a very tight budget and would prefer a one off payment, and not be tied to subscription services
Assuming no other information about what you need to do with your database, I would go with a non-subscription based version of Microsoft Access (you might already have it installed if you downloaded Microsoft Office recently). You can then link MS Access to Excel if you need to do analysis.
If your budget is too tight for that, I would suggest simply using the table functionality (though limited) of Excel to store data in the interim since you have 1,048,576 rows to work with. Of course, it depends heavily on how your data is created, how you mine it from its source, how you want it stored, how accessible it needs to be to other specific programs for analysis, how large the data set is, etc. There are more robust software packages, but they might not be very budget friendly for a small business.
Would be happy to chat about exactly what you are trying to do and provide additional insights.
Linux + MariaDB (Fast MySQL).
Enterprise level throughput + scalability.
Cost == $0.
Well, cost included with whatever hosting you're using.
I run a private hosting company. Some of my machines are running 250,000+ uniques/hour + have been for months.
MariaDB can handle whatever load you throw at it...
Well... so long as your coders know how to write high speed code.
Most coders are clueless about this.
Tip: Pay for expensive developers up front + you'll save huge amounts of money avoiding rewrites.
We are just migrating from Insightly to Agilecrm.com. Take a look - it's fully featured and very good value. We are using it to replace Mailchimp and Campaign Monitor and FeedBlitz for some of our clients.
This is CRM database software - so may not suit your needs. But it's subscription; BUT it's low cost subscription.