I have a database with some tables "Products, Cores, Clients, ProdCliPrice, etc"
I am developing a software and one of it's functions is to update (or insert) the data in an Excel file to my database.
The Excel file contain a ProductID, a Core Name and a Product Price.
I wrote a code that stores all Core Names and Ids to a array, and then, line by line insert (or update if already exists) the product to the database. Since I have more than 100k rows, it is taking too long.
Could you help me with a better way to insert or update these data?