Timeline for Magento 1: caching SQL queries using Magento cache
Current License: CC BY-SA 3.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 22, 2016 at 13:35 | answer | added | Ivan Chepurnyi | timeline score: 6 | |
| Oct 22, 2016 at 11:56 | comment | added | Raphael at Digital Pianism | @ParasSood sweet any you could share what you've done so I can maybe base my dev on what you've done | |
| Oct 22, 2016 at 11:47 | comment | added | Paras Sood | @RaphaelatDigitalPianism Magento's salesrule validation can be heavy in checkout. We added a layer of memcache to cache query results, similar to what you're doing here in principle. | |
| Sep 30, 2016 at 16:25 | history | tweeted | twitter.com/StackMagento/status/781892690170482688 | ||
| Sep 30, 2016 at 8:31 | comment | added | Raphael at Digital Pianism |
@fschmengler yeah me too. Again the code I posted is a draft. Implementing the __wake / __sleep method is definitely required as well as taking care of the store id. But according to my tests it has some potentiel
|
|
| Sep 30, 2016 at 8:30 | comment | added | Fabian Schmengler | 12k - could be worse. Curious if somebody has tested this in the wild. | |
| Sep 30, 2016 at 8:25 | comment | added | Raphael at Digital Pianism |
@fschmengler regarding the load time. Without cache: 0.0015868822733561 seconds . With cache: 9.7366174062093E-5s (notice the E-5 in the end of that time)
|
|
| Sep 30, 2016 at 8:23 | comment | added | Raphael at Digital Pianism | @fschmengler 12ko per product :/ | |
| Sep 30, 2016 at 8:23 | history | edited | Raphael at Digital Pianism | CC BY-SA 3.0 |
added 289 characters in body
|
| Sep 30, 2016 at 8:22 | comment | added | Fabian Schmengler | interesting, then there are probably sleep/wakeup methods at the relevant places. Did you check how much memory the products take in the cache? That could possibly be a limitation | |
| Sep 30, 2016 at 8:17 | comment | added | Raphael at Digital Pianism | @fschmengler yes I tried and it works perfectly fine. Crazy good results in terms of speed. | |
| Sep 30, 2016 at 8:14 | comment | added | Fabian Schmengler | Did you try it? I don't think serializing the whole model like this will work (keep in mind what a huge object structure is attached to the active record models, including resource model and database connection) | |
| Sep 30, 2016 at 7:33 | history | edited | Raphael at Digital Pianism | CC BY-SA 3.0 |
added 127 characters in body
|
| Sep 30, 2016 at 7:20 | history | asked | Raphael at Digital Pianism | CC BY-SA 3.0 |