Sitecore Stack Exchange is a question and answer site for developers and end users of the Sitecore CMS and multichannel marketing software. It only takes a minute to sign up.
Sign up to join this community
I have a script that goes and queries a string from a field box.
Issue: This script takes too long! How can I improve the time to get results?
Set-Location master:
Get-ChildItem -Path "master:\\sitecore\content" -Language * -Recurse -Force |
ForEach-Object -Process {
if ($_.InnerData.Fields | Where-Object {$_.value -match 'Dynamics CRM'}) {
$_.Paths.FullPath | Write-Log
}
}
From what I can tell given the above, you are trying to search the entire tree for instances of Dynamics>CRM and writing the path to a log, you might see some better times from a fast:// query since it does not care about order given the tree compared to the Get-ChildItem:
$query = "fast:/sitecore/content//*[@Field1 = 'Dynamics>CRM' or @Field2 = 'Dynamics>CRM']"
Get-Item -Path "master:" -Language * -Query $query | ForEach-Object { $_.Paths.FullPath | Write-Log }
You could also try and leverage your indexes:
$root = (Get-Item "master:/sitecore/content/")
Find-Item -Index sitecore_master_index `
-Criteria @{Filter = "DescendantOf"; Field = $root },
@{Filter = "Contains"; Field = "field1"; Value = "Dynamics>CRM"},
@{Filter = "Contains"; Field = "field2"; Value = "Dynamics>CRM"} |
Initialize-Item | ForEach-Object {$_.Paths.FullPath | Write-Log }
I would say the only real deviation from my above scripts to what you provided is defining fields to search by compared to just searching all things everywhere. That tidbit alone might help you speed things up.
Full Width box, is it a field on an item? If so you should be able to swap out Field1 for Full Width box or field1 for full_width_box respectively in the snippets above. The output will be the item path, similar to your original post.
A non-SPE approach is to use the out-of-the-box Search tab.
/sitecore/Content itemcustom: (tab)fieldname|Dynamics>CRMIt should return all items with a field of fieldName with a value of Dynamics>CRM. It has the added benefit of using the index by default, so it will be very quick. This doesn't write to the log, but perhaps that wasn't a requirement.
Search And Replace
From the search tab, you can also replace values.
Type in the existing word (Dynamics>CRM) and the replacement.
