Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Personally I think the biggest boost you would get if you started using the community PowerShell implementation over the Rocks one.</p> <p><strong>Let me explain why.</strong></p> <p>You're traversing the whole tree which means you have to visit every node in your branch, which means it has to be read and travel over the Rocks web service at least once. Then every property save is another webservice call.</p> <p>I have run your script in the community console and it took me around 25 seconds for 3724 items. (I've removed the modifications as the values didn't relate to my system).</p> <p>A Simple</p> <pre class="lang-powershell prettyprint-override"><code>Get-ChildItem -recurse </code></pre> <p>On my 3724 item tree took 11 seconds in the community console vs 48 seconds in the Rocks implementation.</p> <p>Additional tweaks you could use in the Community implementation for your script would be using the Sitecore query like:</p> <pre class="lang-powershell prettyprint-override"><code>get-item . -Query '/sitecore/content/wireframe//*[@@TemplateName="Template Folder"]' </code></pre> <p>and only send those items into your function</p> <p>None of it means the Rocks console is not written right, it just means the design choices in the Rocks console and their target is different.</p> <p>You can find the community console here: <a href="http://bit.ly/PsConScMplc" rel="nofollow">http://bit.ly/PsConScMplc</a></p>
    singulars
    1. This table or related slice is empty.
    1. POWhy is this PowerShell script so slow? How can I speed it up?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USSzymon Kuzniak
    1. USAdam Najmanowicz
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWhy is this PowerShell script so slow? How can I speed it up?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIt makes sense that traversing over the network is slow. I found that plugin while I was waiting on the script to complete. I'm still trying to grasp how it works. It looks like I need to install it as a package on the environments I want to run it on - is that right? Our deployment process completely replaces all the `.dll`s - Sitecore's and ours - on our servers; would that wipe out the installed packages like this? I guess the items added to the content tree by the package would persist. Would I just need to get some powershell dll or some such into source management somewhere?
      singulars
      1. PO
      1. USPatrick M
    2. COInstalling the package will bring all the required bits. If you have the console items deployed in your database you can simply copy the files that are in the package. (If you unzip it just take the files in the "files" folder and integrate it into the build. Other than this it uses the PowerShell deployed on your server. As to how you would create and use your script: You can either use the interactive terminal that will show in the Start menu directly, or preferably the PowerShell ISE that you can find in the "Development Tools" sub-menu in the Start menu.
      singulars
      1. PO
      1. USAdam Najmanowicz
    3. COOn a related note, what's your favorite reference for learning the query syntax you use for your get-item guy there? In searching for a guide/beginners tutorial, I've only been able to find singular one-off tips&tricks type articles, nothing comprehensive to really be able to learn it.
      singulars
      1. PO
      1. USPatrick M
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload