Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
I have recently moved over a drupal commerce site to a MongoDB in which each order possess a few field collections with an average 35 fields in the combined collections. I am trying to index the proper collection within the MongoDB, but do not know the frequently used SQL query calls on the backend of this module for read and write calls in terms of the embedded fields. What SQL querys are most frequently used within the module to read/write the embedded fields within a field collection such that we may be able to set up an optimal index?
Comments
Comment #1
jmuzz CreditAttribution: jmuzz commentedGiven an SQL query object you can see the SQL if you print it out as a string. You can use getArguments() to find the details about the values passed.
It may be worth giving the devel module a try too because it has the option to display all the queries run for each page load.
Hope this helps.