search

MicroStrategy / mstrio-py

Python integration for MicroStrategy
Apache License 2.0
90 stars 60 forks source link

Asynchronous fetching #178

Open martinuphoff opened 7 months ago

martinuphoff commented 7 months ago

I am struggling to build up a reporting tool for shortcuts and attributes, sttribute forms, etc. The bottleneck at the moment is to load the individual attributes by id into the python program. Is there any possibility to use asynchronous code for that? I tried with asyncio but the connection seems to be limited to the standard pool size of 10, hence I get and urllib3 error there. Regards, Martin

martinuphoff commented 7 months ago

Update: I used a semphore to limit the number of threads. I boosted the execution time by roughly a factor of 2 and I noticed, that increasing the number of workers beyond 3 does not make a measureable difference. Is this a limit I configure on the Iserver (e.g. a maximum number of jobs per user)? Regards, Martin

apiotrowskiMicroStrategy commented 1 month ago

hi @martinuphoff

We need to further review the applicability of this request to become an integral mstrio-py feature.

I'll get back to you when an action is decided and if further details are required.