||Re: complex indexes vs index key fields
Akshat Kapoor <firstname.lastname@example.org>
||Tue, 28 Jul 2020 17:16:23 +0530
On 28.07.2020 16:54, Gaetano De Luisi wrote:
> The connection timed out at some stage and only half the records got loaded, my comp probably went to power saving mode after 30 mins, 30*350 is just under the 13k records that were loaded, that's probably what happened.
> I will have to find another way because that is not manageable. Perhaps FTP the CSV file and import on the server using the SQL query window.
If this is possible then this will be the fastest as upload of csv files
will be fast and rest of the processing will be on the server itself.
But if it is a recurring task then it may not be that practical to log
in with administrator credentials etc.
If you opt for this then you will be needing a web page that will upload
the csv file and import it.