[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Magento Indexing

Posted on 2016-08-11
1
Medium Priority
?
184 Views
Last Modified: 2016-08-16
What i don't understand is that the indexing is supposed to run as a 'background' process, but reindexing is also done when an individual change is made , why does it need to run in the background as well and how does it run unless on a cron job as php is not multi-threaded? (The docs claim it happens in the background automatically althouth that maybe we with Enterprise docs and the cron jobs run without being set up, maybe??)
0
Comment
Question by:Silas2
1 Comment
 
LVL 18

Accepted Solution

by:
Lucas Bishop earned 0 total points
ID: 41757055
I'd add some SQL topics to this question to get the DBAs in here. Magento uses the EAV data model.

I believe the way it's structured, causes tables to be dropped and rebuilt when you make changes. If you have a huge store (ex. 10k items), the rebuild process can take hours to complete. These rebuilds are managed by MySQL triggers afaik.

Magento also recommends setting up the indexing to be handled via cron, if you have multiple admins changing the store data at the same time.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Original post  on Monitis Blog. Web performance monitoring is broken into two camps: passive and active. Passive monitoring is defined as looking at real-world historical performance by monitoring actual log-ins, site hits, clicks, requests for …
Originally, this post was published on Monitis Blog, you can check it here . It goes without saying that technology has transformed society and the very nature of how we live, work, and communicate in ways that would’ve been incomprehensible 5 ye…
The viewer will receive an overview of the basics of CSS showing inline styles. In the head tags set up your style tags: (CODE) Reference the nav tag and set your properties.: (CODE) Set the reference for the UL element and styles for it to ensu…
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question