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

jmuzz’s picture

Issue summary: View changes
Status: Active » Fixed

Given 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.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.