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
1 replies
Aggregate functions unsupported type MYSQL_TYPE_NEWDECIMAL
Hello, when I try to use aggregate functions in my sql queries, Windmill returns the query result as "unsupported type MYSQL_TYPE_NEWDECIMAL". So a simple example would be a query like "SELECT SUM(Revenue) FROM Orders;". So far I have been using a work around and casting: "SELECT CAST(SUM(Revenue) AS UNSIGNED) FROM Orders;", however this does not seem to work for more complex queries, for example when trying to calculate with two SUM values. Any advice on this? Thanks
5 replies
Chart onClick Events
Hello, I have created a line chart with Chart.js and was wondering if it is possible to have an event triggered, for example to open a modal with additional information, when one of the data points in the chart is clicked. Can anyone point me into the right direction for this? If this should or can be done with the other chart libraries I would also appreciate information on this. Thanks in advance!
3 replies
Reference component with MySQL
Hello, I've got a MySQL database and want to include the properties of a rangeslider component in my SQL query. The rangeslider has the id h and result[0] is the min value currently selected. My query currently looks like this but it does not work, I have tried different ways of referencing the component.
SELECT Product, (Unit_Price - Unit_Cost) AS db
FROM FullBike
GROUP BY Product, db
HAVING db BETWEEN ${h.result[0]} AND ${h.result[1]}
ORDER BY db DESC;
Is there a way to do this just within the SQL query without an additional script? Thanks in advance
3 replies