I use an Azure SQL database. I'm getting what I think are very slow query times. I've created a really simple query in a Retool app, and I have a powershell script that performs the same query, so I can compare the two. The query is very simple:
select * from product where product_number = convert(int,rand()*100+1000)
(The product table has a int PK starting at 1000 and only has 167 rows)
This query takes an average of 55ms roundtrip via the powershell script, versus 1000-3000ms via Retool.
I know there is significantly more overhead involved with Retool versus the script, but this seems very slow. Does anyone have any idea what might be going on?
Thanks
Maxamillian