I can query my questdb table(fifteen millions rows) by browser in 50ms, however, by python it takes 50 seconds. What may result in the problem? Thank you

I can query my questdb table(fifteenmillions rows) by browser in 50ms, however, by python it takes 50 seconds. What may result in the problem? Thank you.

1 Like

Hi @zhchy75 ,

What does your query and schema look like?

How large is the result set?

When you run a query in the web console, it will cap the result set to 10,000 rows per default. Therefore, depending on your query, it will not necessarily read the whole data set.

When running in Python via psycopg2 or HTTP, it is likely running the whole query and returning the results to you.