Clip Hot

Hài hước

Âm nhạc

Phim hay

Tin mới

Magento for Developers: Part 10 Queries 03

qaisar ali 256 vistas

Magento's use of data models provide a great way to access and modify data. Using aptly named methods and clever abstraction, Varien hide away the complex SQL needed to perform data operations. While this makes learning models easier, it often impacts the speed of the operation and therefore the responsiveness of your site. This is especially true when saving models that use the EAV architecture. More often that not, this cannot be avoided, however there are some situations where executing direct SQL queries would be simpler and much quicker. An example of this is updating product prices globally in Magento. It would be easy enough to write some Magento code that looped through all products and modified the price. On a large data set, saving each individual product can take a long time and therefore make the system unusable. To combat this, it is possible to issue a direct SQL query which could update 1000's of products in 1 or 2 seconds.

Comments
Loading...
Keyword search
How To Use Magento Metallica Nothing Else Matters How To Dr Willie Keuringsdienst van waarde Observer Design PatternDay Trading Covert Narcissist Signs You Introduction to Τι δεν σου Seminar on EAV Inside an Swift Programming Tutorial Dissolving Karma Hash Tables and Import bulk products in Magento Community Tutorials #37 Magento Community Tutorials #0 5 Continuing a Quick Start to Magento How To Use Metallica Nothing Else How To Dr Willie Keuringsdienst van waarde Observer Design PatternDay Trading Covert Narcissist Signs You Introduction to Τι δεν Seminar on EAV Inside an Swift Programming Tutorial for Dissolving Karma Through Hash Tables and Hash Import bulk Magento Community Tutorials Magento Community Tutorials Continuing a relationship with Quick Start How To Use Magento Metallica Nothing Else Matters How To Solder Copper Dr Willie Soon Keuringsdienst van Observer Design PatternDay Trading Live with Covert Narcissist Signs You Introduction to Magento Τι δεν σου Seminar on EAV Inside an $11 Million Swift Programming Tutorial Dissolving Karma Through ForgivenessHash Tables and Hash Import bulk products in Magento Community Magento Community Tutorials #0 5 Continuing a relationship Quick Start to Magento How To Use Metallica Nothing Else Matters How To Solder Dr Willie Soon demolishes Keuringsdienst van Observer Design Day Trading Live Covert Narcissist Introduction to Τι δεν σου είπαν Seminar on EAV Inside an $11 Million Swift Programming Tutorial for Dissolving Karma Through Hash Tables and Hash Import bulk products Magento Community Tutorials Magento Community Tutorials #0 5 Continuing a relationship with Quick Start How To Metallica Nothing How To Solder Copper Dr Willie Soon demolishes Keuringsdienst van waarde Observer Design PatternDay Trading Live with Covert Narcissist Introduction to Τι δεν σου είπαν Seminar on EAV Data Inside an $11 Million Swift Programming Tutorial Dissolving Karma Through ForgivenessHash Tables Import bulk Magento Community Tutorials Magento Community Tutorials Continuing a relationship Quick Start to