Forum Replies Created
- AuthorPosts
- December 16, 2019 at 6:29 pm in reply to: Klarna Payment integration –> Activation of Klarna Orders #97641Michael WidegrenParticipant
I am using Stripe at the moment, what would be needed for the use of the Klarna api ? :
https://stripe.com/docs/sources/klarnaWould be nice to have the option for my customers
Michael WidegrenParticipanthere’s WooCommerce report (the most similar in terms of sql queries)
it finished in 2 secondsAttachments:
You must be logged in to view attached files.Michael WidegrenParticipantit seems that there are around 300 sql queries, and they take approx. 0.5seconds to complete, which equals around 130seconds total, so how do I fix this?
Michael WidegrenParticipanthere are the results, it took the database 130 seconds to get the data for the second screenshot (WooCommerce reports takes like 0.4 seconds to generate)
Attachments:
You must be logged in to view attached files.Michael WidegrenParticipantA little more digging,
When generating a Report, everything is fast and so on when generate it by date/month/year. But as soon as I am trying to generate a report based on Vendor it slows down and takes forever (or until my apache/php time limit steps in)so there must be a bug or something causing this, I am trying to use Query Monitor to get a query so that I can run it directly on the database and measure speed. I’ll let you know
Michael WidegrenParticipantHi and thanks for replying!
there are no error in the fatal_errors log.
I have a own VPS with Debian 9 + LAMP installation. there are no error that are related to this, more than the php log timout. I have checked the MariaDB slow query log (not in there) , the apache logs (nothing) …only the php log as shown above.
other pages works fine, and fast. I have since tweaked my site to go under 500ms per page view.
I was thinking, is it possible to comment out different sql queries that are in the Dashboard ? so that I might find the query that is slow.which php file is responsible for the dashboard queries?
Michael WidegrenParticipantOMG! I’ve been looking everywhere!!! But I missed that! Thank you so much, I feel soo stupid right now 😀
Thanks!!
Michael WidegrenParticipantabsolutely perfect!! Thanks for your support and doing all of this!!
August 4, 2019 at 7:03 pm in reply to: Trouble with Home in the Dashboard of marketplace plugin #75210Michael WidegrenParticipantGood to hear that I am not alone. I have not that many products but a lot of downloads (30000 right now) and 4000 orders, it takes me around 5-10 minutes to open up (if it ever does)
luckily my vendors only experienced slight delayI am guessing there are a lot of advanced db questions that is the culprit. since the home dashboard is a report (reports however is very fast), the vendor list page is also slow, everything else is quick 😀
- AuthorPosts