blacktambourine

<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/" xmlns:set="http://www.sitecore.net/xmlconfig/set/" xmlns:role="http://www.sitecore.net/xmlconfig/role/">
  <sitecore>
    
    <!-- START Dev environment optimisations-->
    <settings>
      <setting name="ContentTesting.AutomaticContentTesting.Enabled" value="false"/>
      <setting name="Counters.Enabled" value="false"/>

      <setting name="Xdb.Enabled" value="false"/>
      <setting name="Xdb.Tracking.Enabled" value="false"/>

blacktambourine

<?xml version="1.0"?>
<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/">
  <sitecore>
	<eventing defaultProvider="sitecore">
	 <eventQueueMonitor>
		<!-- 180411 PS: increased this from 2 seconds to 10; fix for issue with CD instance scaling out -->
		<processingInterval>00:00:10</processingInterval>
	 </eventQueueMonitor>
	</eventing>
  </sitecore>

blacktambourine

<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/">
  <sitecore>
    <!--Clear the html cache on publish; default only clear for site called "website"-->
    <events>
      <event name="publish:end">
        <handler type="Sitecore.Publishing.HtmlCacheClearer, Sitecore.Kernel" method="ClearCache">
          <sites hint="list">
            <site>MyWebsite1</site>
            <site>MyWebsite2</site>
          </sites>

blacktambourine

SELECT ID, [Name], cast([dbo].[SC_GetSharedFieldValue] (ID, '{6954B7C7-2487-423F-8600-436CB3B6DC0E}') as int) AS FileSize
 FROM [dbo].[Items]
 ORDER BY FileSize DESC

blacktambourine

CREATE FUNCTION [dbo].[SC_GetSharedFieldValue] 
(
 @ItemID [uniqueidentifier],
 @FieldID  [uniqueidentifier]
)
RETURNS nvarchar(max)
AS
BEGIN
 DECLARE @Result  nvarchar(max)
 SELECT @Result = value 

blacktambourine

<?xml version="1.0" encoding="utf-8" ?>
<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/" xmlns:set="http://www.sitecore.net/xmlconfig/set/">
  <sitecore>
    <contentSearch>

      <configuration type="Sitecore.ContentSearch.ContentSearchConfiguration, Sitecore.ContentSearch">
        <indexes hint="list:AddIndex">
          <!-- add in the flights search index -->
          <index id="flight_json_index" type="Sitecore.ContentSearch.LuceneProvider.LuceneIndex, Sitecore.ContentSearch.LuceneProvider">
            <param desc="name">$(id)</param>

blacktambourine

using System;
using System.Collections.Generic;
using System.Globalization;
using MyCustomModels.Flights.Model;
using Sitecore.ContentSearch;
using Sitecore.ContentSearch.Converters;
using Sitecore.Data;
using Sitecore.Diagnostics;

namespace Business.Search.Json

blacktambourine

using Sitecore.Data;
using Sitecore.Sites;
using System;
using Sitecore.Configuration;
using Sitecore.ContentSearch;

namespace Flights.Tasks
{
    public class FidsJsonTask
    {

blacktambourine

using System;
using System.Collections.Generic;
using System.Globalization;
using System.Linq;
using System.Threading;
using Newtonsoft.Json;
//using CustomModel.Flights.Model;
using Sitecore.Collections;
using Sitecore.ContentSearch;
using Sitecore.ContentSearch.Abstractions;

blacktambourine

:SETVAR DatabasePrefix sc9test_ 
:SETVAR UserName collectionuser 
:SETVAR Password Test12345 
:SETVAR ShardMapManagerDatabaseNameSuffix _Xdb.Collection.ShardMapManager 
:SETVAR Shard0DatabaseNameSuffix _Xdb.Collection.Shard0 
:SETVAR Shard1DatabaseNameSuffix _Xdb.Collection.Shard1 
GO 
 
IF(SUSER_ID('$(UserName)') IS NULL) 
BEGIN