Are your Drupal views slow? Do your clients forget what they are searching for? Have your clients stopped using a feature, dashboard, or report because of performance? After reading this post you will learn how to convert your slow queries into efficient queries and dramatically improving render time while satisfying your clients.
You may need to visually represent a flat hierarchy to render a full relationship. You may also need to import and export content with a flat hierarchy in order to maintain the proper parent child relationships. One method of defining relationships in Drupal is with taxonomies. When working with Drupal 7’s Taxonomy API, you will find it does have a method for listing terms and their parents. In order to provide a list of terms with their parents, you will have to perform multiple Taxonomy API calls.
Drupal’s Batch API was created for processing large data sets while avoiding PHP’s max execution time. When using the Batch API separate your processing into different segments. When applying this approach to operating on a CSV file it is natural to segment on each row. Separating each row into its own process mean PHP’s max execution time will only count for the time it takes to process each row, providing practically unlimited operation time.