django-clickhouse-backend icon indicating copy to clipboard operation
django-clickhouse-backend copied to clipboard

Published 20 hours ago • verified publisher icon jayvynl

[BUG] - Package taking time to render response.

Open vigneshshettyin opened this issue 1 year ago • 7 comments

Describe the bug Observed a case where when the query string is long, Package is taking more time to render data. Also ran a profiler and checked that database is returning result instantly (less than 500ms) but django is taking more 30-35 seconds.

Query string length is 575316 characters, this is raw SQL length

With lower query string it works fine.

To Reproduce Trigger API with higher query string (approx more than 575316)

Expected behavior Django should return response within 1-2 seconds

Versions

  • ClickHouse server version. Version can be obtained by running SELECT version() query. - 23.12.1.956
  • Python version. - 3.11
  • Clickhouse-driver version. 0.26
  • Django version. - 4.2
  • Django clickhouse backend version. 1.14

image (1) image

vigneshshettyin avatar Dec 21 '23 11:12 vigneshshettyin