It takes 3-5 minutes to open the HomePage when first visit, product detail page takes more than 30 seconds, after that, its fast when visit again, it's quite slow that customers can't stand. My store contains 550000+ products and 3 languages, Is it the problem?
Besides, sometimes after about half an hour without any operation it slows again, but sometimes not, I cant find the rules.
I found there are many thouands of LocalizedProperty query are executed when debug the application,
Would these data be cached after loading? How can I manage caches by myself?