• Charles Koppleman
  • NEWBIE
  • 20 Points
  • Member since 2015

  • Chatter
    Feed
  • 0
    Best Answers
  • 1
    Likes Received
  • 1
    Likes Given
  • 1
    Questions
  • 1
    Replies
When I query string columns on custom metadata objects, I get decent performance.  However, if I query a column that points to a FieldDefinition, my query became much slower.

Is this a known system bug?  Is there a patch on the horizon?

It makes these relationships really unusable.

Here are profiling logs on a sandbox after priming the pump (I'll just include the SOQL profiling):

Querying a String takes 19ms.

    for (My_Metadata__mdt m: [SELECT Id, String__c FROM My_Metadata__mdt]) {
        System.debug(m.id);
    }

    AnonymousBlock: line 1, column 1: [SELECT Id, String__c FROM My_Metadata__mdt]: executed 273 times in 19 ms

Query a FieldDefinition takes about half a second!

    for (My_Metadata__mdt m: [SELECT Id, Field__c FROM My_Metadata__mdt]) {
        System.debug(m.id);
    }

    AnonymousBlock: line 1, column 1: [SELECT Id, Field__c FROM My_Metadata__mdt]: executed 273 times in 511 ms
When I query string columns on custom metadata objects, I get decent performance.  However, if I query a column that points to a FieldDefinition, my query became much slower.

Is this a known system bug?  Is there a patch on the horizon?

It makes these relationships really unusable.

Here are profiling logs on a sandbox after priming the pump (I'll just include the SOQL profiling):

Querying a String takes 19ms.

    for (My_Metadata__mdt m: [SELECT Id, String__c FROM My_Metadata__mdt]) {
        System.debug(m.id);
    }

    AnonymousBlock: line 1, column 1: [SELECT Id, String__c FROM My_Metadata__mdt]: executed 273 times in 19 ms

Query a FieldDefinition takes about half a second!

    for (My_Metadata__mdt m: [SELECT Id, Field__c FROM My_Metadata__mdt]) {
        System.debug(m.id);
    }

    AnonymousBlock: line 1, column 1: [SELECT Id, Field__c FROM My_Metadata__mdt]: executed 273 times in 511 ms
I am trying to copy workflows (field updates and rules) from one org to another using eclipse force.com ide.  I used this source code copy/paste method for fields, validation rules, record types, etc. with no problem.  What went wrong?  I am getting "Error parsing file: Element fieldUdates is duplicated at this location in type Workflow"
Any idea how to fix this?
I am trying to copy workflows (field updates and rules) from one org to another using eclipse force.com ide.  I used this source code copy/paste method for fields, validation rules, record types, etc. with no problem.  What went wrong?  I am getting "Error parsing file: Element fieldUdates is duplicated at this location in type Workflow"
Any idea how to fix this?