search

keboola / ex-teradata

MIT License
0 stars 0 forks source link

Longer timeout #42

Open padak opened 5 years ago

padak commented 5 years ago

Based on research in https://keboola.zendesk.com/agent/tickets/9714 client asked us to extend existing 1 min timeout in DIBI to 15 min. Lot of queries are terminated just because DB wasn't able to do a first response under 60 sec.

Is that possible? Alternatively, are we able to let users to configure it (lets say in some defined boundaries - i.e. 1 min ~ 20 min)?

padak commented 5 years ago

@Actimel Davide, je to věc co zabere pár minut? Pokud ano, mohl bys to zvednou, prosím?

Actimel commented 5 years ago

@padak Promin, za takovy delay. Bohuzel to na par minut nebude, zkousel jsem si pohrat s tim timeoutem, ale bez uspechu. Dale i zkusit dalsi ruzna nastaveni pro pripojeni, ale stale se mi to pri dlouhem query polozi vetsinou po 5 minutach (rozdil oproti 1 minute v tiketu). Nahodil jsem i nejnovejsi ODBC driver, ale nic.

Zvlastni je, ze oni jen exportuji tabulku, coz by melo frcet rychle (i kdyz je vetsi) a nasledne fetchovani uz je na toto delane. IMHO by pomohlo pridani incrementalniho fetche a nastahovat to po mensich davkach #25.

padak commented 5 years ago

@Actimel mignul jsme to na chvíli sem https://keboola.slack.com/archives/C035LGNK5/p1549623574032800