var s = oFile.ReadLine();
var sArr = s.split(",");
var sPostcode = String(sArr).replace(re, "");
var sSuburb = String(sArr).replace(re, "");
...stored procedure to write into database...
It works fine for smaller csv files (1,000 lines), but for larger files, it comes across a 504 error. Does anyone know a fix to this?
How are you trying to insert the data into the database?
You said you are using JS and ASP. The JS is reading the file and sending the data to the ASP server page to insert into the database? Is that right? If so, then the your http request is pretty big and would take some time to complete.
Assuming you are using IIS, you can try to change the limits of the http request, like this: