Re: Any insights on Qlik Sense using CURSOR ?

Hi, On Tue, May 18, 2021 at 6:22 PM Franck Routier (perso) wrote: > Hi, > > I am using postgresql 12.7 on Ubunut as a datawarehouse, that is then > queried by QlikSense to produce business analytics. > > One of my dataloaders, that runs multiple queries, sometimes takes about > 3 hours to feed Ql

Re: Any insights on Qlik Sense using CURSOR ?

Thanks Ganesh, this gave me the select that is slow. It effectively looks like this: begin; declare "SQL_CUR4" cursor with hold for select ... then a bunch of: fetch 10 in "SQL_CUR4" then a commit I also found this article  https://www.cybertec-postgresql.com/en/declare-cursor-in-postgres