Forum Replies Created
- AuthorPosts
- December 16, 2019 at 6:29 pm in reply to: Klarna Payment integration –> Activation of Klarna Orders #97641
Michael Widegren
ParticipantI 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 Widegren
Participanthere’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 Widegren
Participantit 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 Widegren
Participanthere 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 Widegren
ParticipantA 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 Widegren
ParticipantHi 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 Widegren
ParticipantOMG! I’ve been looking everywhere!!! But I missed that! Thank you so much, I feel soo stupid right now 😀
Thanks!!
Michael Widegren
Participantabsolutely 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 Widegren
ParticipantGood 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