delay in extracting data from the database

[gabrielfs2]

Hello everybody

recently my company moved my SQL database to another country, with that extractions are showing a lot of slowness, is there any way to reduce the extraction delay by increasing the sessions with the database, or another way?

[denisfi]

Hi @gabrielfs2 ,

Maybe you can select a limit of rows at the request process for your database, getting less rows as expected but quicklier to process.

At the database connector you can set some options. Example for mysql database:

Here you can set reconnection process if timeout happens as automatically.

At here, you can set manually some settings that can help you, but you need to understand this complex setup.

I hope that it helped you.

Regards,

Denis