Sequelize query Performance issues with associations

138 views
Skip to first unread message

empty boats

unread,
Mar 30, 2021, 11:49:05 AM3/30/21
to Sequelize

I'm trying to upgrade a Node app from Sequelize v3 to v6 that uses a Mysql db. The queries involving model associations/relationships are much slower on v5/v6 than they are on v3/v4. It almost seems like Sequelize isn't using the table indexes when doing inner or outer joins? Or is there some other change in v5 I'm missing to speed up queries on model relationships? Whether using node 10/12/14 doesn't seem to make a difference. 

Roye

unread,
Jun 16, 2023, 2:11:23 PM6/16/23
to Sequelize
Sequelize just builds the queries for you. You can log the queries to see if indexes should be tuned
Reply all
Reply to author
Forward
0 new messages