Number of connections to database is much higher then numbers of queries, why?

Asked May 22 '17 at 07:54

Active May 22 '17 at 07:59

Viewed 95 times

I was watching how my application behaves with Glimpse(web diagnostic tool), and could not explain why number of connections to db is much higher then actual queries. I look at particular ajax call to db, which loads 10 more Entities to view each time list is being scrolled to bottom.

13 Queries are because of lazy loading, but i can't explain why so much connections to db (92). When I tested it on more simple application, while eager loading, there was just one connection to db, and while lazy loading #connections was equal to #queries. What can cause this behavior and how does it impact performance?

Edit: I'm using mysql.

edited May 22 '17 at 07:59

asked May 22 '17 at 07:54

sneuly

SQL is a language. Specify dbms instead. – jarlh May 22 '17 at 07:55
1

I'm using mysql in both cases, edited question, thank you for tip – sneuly May 22 '17 at 07:59
Although [this question](https://dba.stackexchange.com/questions/65669/high-number-of-connections) on DBA SE is for SQL Server, it may be related? – Timothy G. May 22 '17 at 11:51

Number of connections to database is much higher then numbers of queries, why?

0 Answers0