Thanks you for your answer but is there no way to make it in one SQL statement ? Executemany will make as many insert statements as number of rows to add, which is way slower especially with a large ...