Subject Re: complex indexes vs index key fields From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Tue, 28 Jul 2020 17:16:23 +0530 Newsgroups dbase.getting-started 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. Regards Akshat