Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have a file with only one column and each line of the column is an update query; approx 10000 update statement.
The problem is that it is taking too much time to execute each query => more than 6 hours.
The database is mySql and i am using the component tDBRow, but as you can see below the option is greyed out in talend and unable to check.
My question is that: is there another way how i can launch multiple query at the same time ?
Or is there a way to enable the parallel execution or any other component which i can use?
Best regards,
RA
if you just need better performance, I'd start with changing select to "SELECT DISTINCT user_id" instead of selecting a lot of duplicates and extra columns.
i am not using any select statement in my update query; this option is not applicable in my case.
All the updates are in a 1 file that 10 rows means 10 update statement and besides they are simple and straight updates, no subquery at all. 😕