Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Magento Indexing

Posted on 2016-08-11
1
102 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 17

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
craigslist auto renew posts 3 40
Two wordpress questions 3 62
hbo knew my windows software 4 62
How to use NFS (Network File System) in Asp.net mvc 5? 4 45
Any business that wants to seriously grow needs to keep the needs and desires of an international audience of their websites in mind. Making a website friendly to international users isn’t prohibitively expensive and can provide an incredible return…
Businesses who process credit card payments have to adhere to PCI Compliance standards. Here’s why that’s important.
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

838 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