2. PHPRunner General questions
  3. [SOLVED] Tips and Tricks for host configuration for import of large no of records via CSV Import
This topic is locked
[SOLVED]

Tips and Tricks for host configuration for import of large no of records via CSV Import

 		6/5/2024 11:47:05 AM
PHPRunner General questions
Dalkeith author

Dear all

I suspect my host Azure is limiting import of records into my database.. PHPRunner 10.91 linked to SQL Server (Application front and back end hosted in Azure)

If I am wanting to allow imports of 50k of records are there any recommendations for configuration that allows for the maximum import of records via the csv import process.
e.g is it a phpconfig issue - I have seen that is the case with file uploads for instance..

Here I am talking specifically of import of csv files into a table from a list screen.

Thanks in advance
C
 		cristi 6/5/2024

Two lines in php config mainly contribute to this:

  1. max_execution_time - the time that php runs the script - if the import is too large or the bandwith is low it will take a lot of time and PHP will stop execution and report an error - so try to increase that: default is 30 (seconds), try to change to 180 for example...
  2. memory_limit - this is the usual suspect for a lot of scripts - try increase if possible the allocated memory for the execution of scripts: default is 128 (MB) - increase to 512 for example
Dalkeith author 6/5/2024

Brilliant Cristi just what I was looking for