has anyone used <https://github.com/python-trio/tr...
# troubleshootingt
Tim Chan
10/02/2020, 7:58 PMhas anyone used https://github.com/python-trio/trio to try to run concurrent queries with https://github.com/python-pinot-dbapi/pinot-dbapi
Tim Chan
10/02/2020, 7:58 PMno matter what i do, i’m seeing my queries run sequentially
k
Kishore G
10/03/2020, 6:00 AM
@Xiang Fu do you know if this is expected?
x
Xiang Fu
10/03/2020, 7:44 AM
I haven’t tried out trio, but for python, you need to have your “concurrent” framework to send parallel workload
Xiang Fu
10/03/2020, 7:44 AM
also try to init multiple clients to see if that will help
Xiang Fu
10/03/2020, 7:47 AM
for the client, we are not using threading or async, contributions are welcome 😉
t
Tim Chan
10/05/2020, 12:05 AMi did try to use a new connection for each query https://github.com/python-pinot-dbapi/pinot-dbapi/blob/master/pinotdb/db.py#L27
x
Xiang Fu
10/05/2020, 3:45 AM
right, each thread need to have its own connection
Xiang Fu
10/05/2020, 3:45 AM
How is your application running ? How many threads are you expecting to have