-
Notifications
You must be signed in to change notification settings - Fork 21
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[BUG] - Package taking time to render response. #70
Comments
Is it caused by a SELECT query filtering JSON field? |
No, we don't have JSON field @jayvynl |
Let us know if you need more info, we can share. @jayvynl |
@vigneshshettyin What is the query like |
Pls, find the above query, where CODE is the dynamic filter (CODE eg are like PLO92, PLO393, HJO93 ...). When the number of codes are like 10,000 django app performs well. But when the number of codes are more than 40,000 we are facing this issue. |
As shown in your profiling,
|
Ok, let me raise a issue ticket for https://github.com/mymarilyn/clickhouse-driver |
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
SELECT version()
query. - 23.12.1.956The text was updated successfully, but these errors were encountered: