Is there a workable solution to importing large datasets into a DB in server connect?

[famousmag]

I agree with Brian…

I suppose this is a matter of memory… This huge amount of data is loaded on memory taking so much place of it and then the memory resources are low for processing!

The problem must be hidden here:

@Philip_J

due to the CSV file being on the web server and postgres operating on its own DB server.

This Topic has a few very good ideas/advisements:

Slow insert records into the database

@George, have there been any major changes in the repeat component in SC since Wappler ver. 2? It feels like the multi-insert has become slower. Question to the community. Has anyone worked with large data arrays (insert/update)? A large array is more than 500 thousand records. How do you insert records into the database? I measured the insert speed using a pre-prepared csv file with 12,364 records. The server action is extremely simple: [3] Start of the insert: [start1] After 2 minutes, …