I have an ASP page written in JavaScript that writes a CSV file into a database table.
while (!oFile.AtEndOfStream)
{
var s = oFile.ReadLine();
var sArr = s.split(",");
var sPostcode = String(sArr[0]).replace(re, "");
var sSuburb = String(sArr[1]).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?
Help is very much appreciated.