Reply To: Stripe Integration

[Andrey]

#16375

Hello Nishit i have a report from the system team who’s checking server load and behaviour for Dave work and they found that friends account load is very good but on EN project there are some issues that they suggest you to check:

For example we have got fastests CPU and fastests disks but some of DB queries load takes a looong time to respond.
So system team suggest you to verify if there are missing indexes on joins , why a select query is hanging for 27 seconds, which is VERY slow and it should not take so much time, see some screen shots below:

https://webmaklay.com/wp-content/uploads/2026/08/image.png

this happens when you have complex query and you donot have proper indexes used for joining in sql structure.
https://webmaklay.com/wp-content/uploads/2026/08/image-1-1.png

average db query should be 1-2 seconds
Could you please inspect these lines above and improve your queries?