Query Timeouts and Connection

💬 Queries and Resources
, ,
1
  1. My goal:
    Hello, I am trying to create a front end for my Azure Database. The issue that I am facing is with all of my queries. every previous query I had it timing out and when I toggle it to "viewing mode" nothing will input into the db. iI don't think any of my queries are using the * with SELECT, but I guess I really dont know why it isnt working. When restart the browser and load the project, it takes 50+ seconds for every query to load and half of them time out. They used to work, but the longer I have been working on the project, it seems everything is becoming slower and slower. Is it an issue with my laptop?

Thanks in advance

1 Like
2

Hi @hannah_b,

There could be several reasons causing the timeout.

  • Are you able to share the full query? Sometimes there is space for improvement there.
  • how many records should you be getting? This could also be a reason, but usually when you're expecting hundreds of thousands of records
3

Hello, here is the query

SELECT product_lot_num
FROM product_lot;

the query will run for 100+ seconds and there are only 6 rows in the table. I am unable to edit other queries and run them since this one will not work

4

Hi @hannah_b,

Apologies for the issue. I can help trouble shoot but I will need more details in terms of your app and query set up.

Are you on cloud? Can you share a screen recording the the query and what happens when you preview the query and run the query?

1 Like
5

Hi @hannah_b,

I just wanted to follow up and see if you could share more details on your setup and if you can share a video of this behavior.