Is there a best way to import a large number of records - About 315000 to be precise. The company provides a service which is only available to specific addresses. So I had set up a section to contain the addresses where the service is available. With fields - Address1, Address2, Postcode, Town Just got the data to import and discovered that there is 315000 records - I got the data in csv format. Tried with Import and FeedMe Plugins but run into memory issues straight away. CSV file is nearly 15MB and when converted to XML for feedme it is 52MB
So what are my options for importing?
Could I ramp up the resources on a Digital Ocean Server for the time that the import is required?
Or should I try another method to try this lookup service on the website?