This week i was playing with some Mapping stuff and wanted the centre points of a group of post codes in the UK. The only free source i could find was the UK Office of National Statistics who provided the data in a .csv as a singe UK wide file. This contained (as i now know) 2,599,813 records.
I used MySQL Workbench to import the .csv file into a database table.
The setup in use was Windows/ Maria DB community server running on a Core i9, 32GB ram, M2 1GB SSD.
How long do you think it took to import all records?
Groups exclude lower value so 48 hours means less than 48, more than or equal to 24
Old gamers may remember PlanetLAN (we had sites in Germany, Austria, Switzerland, the UK and we did venture in to the US for a while). Besides the US site we imported all the Geo Data for every single postcode for each country to populate our LAN party maps. Enter your postcode set a radius (ie 25 miles) and it would return LAN parties within your specified area. This must have been around 1999 - 2000. I can remember taking a trip to Telehouse in London to one of our racks and doing this for the UK data set. I think it was about 1.5 million records... The nightmare was actually getting the data from the Post Office. Had to jump through all types of hoops and pay a small fortune to license it.
Crazy to think everything Social Media has now we did back then, and more, a real community of like-minded people. Were some fun and challenging times. Your post brings back fond memories @Hyperbytes