Application performance

philthethrill99 · June 19, 2018 1:12PM

Is there a limit on the number of objects that the application can handle and still be performant.

My refresh of my project showed me 22000 objects and the refreshing process took at least 1 hour.

I reopen my project and it restarted the refresh process.

Will the refresh be more efficient if i commit my changes ?

Thanks for your help.

David Atkinson · June 19, 2018 1:19PM

Do all 22000 objects need to be in version control? If you can manage with a subset, we have an upcoming filtering feature that excludes objects so they don't need to be read into the tool and compared, which takes a lot of the time.

philthethrill99 · June 19, 2018 1:24PM

Thanks for your qucik response.

A subset would be possible but it will still be probably 20 000 objects

David Atkinson · June 19, 2018 1:30PM

Please use this link to get the preview build and instructions to try out the pre-filtering feature and let us know how much the improvement is. I believe that the refresh will be quicker once it's checked in.

philthethrill99 · July 6, 2018 3:13PM

Sorry for the late response but the link for preview build provided is no longer working. I'm still with a trial version. Is that an issue to have the preview build ?

David Atkinson · July 7, 2018 4:18PM

philthethrill99 said:

Sorry for the late response but the link for preview build provided is no longer working. I'm still with a trial version. Is that an issue to have the preview build ?

Apologies for this. The link was old - I've updated it now.

philthethrill99 · July 9, 2018 1:57PM

Thanks for the update.
In the Source Control app, i selected "Tables" filter only and put a single table in my json file.
In the logs, i still see queries about other kinds of objects (Triggers, Packages, ...)
Is there a way to avoid that ?
Should i put all types of objects in the json file with an emtyp list?

Thanks for your support.

David Atkinson · July 9, 2018 4:04PM

The following should work.

 {
  "filters": {
    "table": [
      "^ABC\w+",
      "example_table_1",
      "example_table_2"
    ]
    }
}

If you leave the other entries in the file, you can set the values as the empty string. eg:

 "trigger": [
      ""
    ]

Application performance

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk