WindmillWWindmill
Powered by
BestCareAnyLeaB
Windmill•2y ago
BestCareAnyLea

Settings to optimize for large SQL queries?

Hello, is there anything I can do or that I should keep in mind to make sure that large SQL queries run better or even finish at all? I am testing the response time for different tools with large amounts of data (starting from 500.000 rows with two columns) and am running into indefinitely loading queries in windmill pretty quickly. I am using self-hosted on docker. Thanks
WindmillJoin
3,362Members
Resources
Recent Announcements

Similar Threads

Was this page helpful?
Recent Announcements
henri-c

Weekly kenote to tell you about our latest updates https://discord.com/channels/930051556043276338/1278977038430240813 https://youtube.com/live/2dGd9TdT8xs?feature=share

henri-c · 4d ago

Pyra

### HTTP tracing (EE) Capture HTTP requests made by job scripts as observability spans Features: - View HTTP request traces (method, URL, status, timing) in the job details UI - Auto-instrumentation for Native TypeScript, MITM proxy for other languages - Integrates with external OpenTelemetry collectors changelog: https://www.windmill.dev/changelog/http-tracing docs: https://www.windmill.dev/docs/advanced/instance_settings#http-tracing Additionally jobs memory metrics are now fully OSS!

Pyra · 2w ago

henri-c

First keynote of the year here https://discord.com/channels/930051556043276338/1278977038430240813 🙂

henri-c · 4w ago

Similar Threads

Deadline elapsed on SQL queries
ShenanigansSShenanigans / help
2mo ago
Large SQL input field like in the native one
wdesertWwdesert / help
14mo ago
How to pass parameters to SQL query?
jase64Jjase64 / help
2y ago
How to pass sql query parameter
Ask InkeepAAsk Inkeep / help
2y ago