You are not logged in.
What are the suggested optimization settings for a MYSQL and/or MS SQL talend database.
Currently I'm using the 2.3.3 Integration Suite with a project that has 50 jobs. 1 job calls 4 jobs, which 2 of the jobs call 22 to 29 jobs.
So when opening this jobs that call other jobs (Sequencers) they take a long time. This also happens with any save or run.
WHat I'm looking for is any recommended tuning we can do to the MYSQL talend database that would speed this up.
(I would post those images, but I can't get them to generate either). The Generate documnetation takes hours and sometimes doesn't generate the documentation for the overall job and the job that calls 29 other jobs.
you can perform some basic tunning on the MYSQL db. please open the mysql administrator and perform maintenance options by right clicking on all the db tables and choosing the db optimization option. let's see if this improves your performance.