protected override ChangeResponse MakeRequest(ISyncContext context, JanusAT svc,
            ChangeRequest rq)
        {
            bool trace = false;
#if TRACE_SYNC_TIME
            trace = true;
#endif
            using (TimeTracer timeTracer = new TimeTracer("STM:MessagesSyncTask.MakeRequest", trace))
            {
                return svc.GetNewData(rq);
            }
        }

        [System.Web.Services.Protocols.SoapDocumentMethodAttribute("http://rsdn.ru/Janus/GetNewData",
         RequestNamespace = "http://rsdn.ru/Janus/",
         ResponseNamespace = "http://rsdn.ru/Janus/", 
         Use = System.Web.Services.Description.SoapBindingUse.Literal, 
         ParameterStyle = System.Web.Services.Protocols.SoapParameterStyle.Wrapped)]
        public ChangeResponse GetNewData(ChangeRequest changeRequest)
        {
            object[] results = this.Invoke("GetNewData", new object[] {
                        changeRequest});
            return ((ChangeResponse)(results[0]));
        }

AN>        protected override ChangeResponse MakeRequest(ISyncContext context, JanusAT svc,
AN>            ChangeRequest rq)
AN>        {
AN>            bool trace = false;
AN>#if TRACE_SYNC_TIME
AN>            trace = true;
AN>#endif
AN>            using (TimeTracer timeTracer = new TimeTracer("STM:MessagesSyncTask.MakeRequest", trace))
AN>            {
AN>                return svc.GetNewData(rq);
AN>            }
AN>        }

AN>

        [System.Web.Services.Protocols.SoapDocumentMethodAttribute("http://rsdn.ru/Janus/GetNewData",
AN>         RequestNamespace = "http://rsdn.ru/Janus/",
AN>         ResponseNamespace = "http://rsdn.ru/Janus/", 
AN>         Use = System.Web.Services.Description.SoapBindingUse.Literal, 
AN>         ParameterStyle = System.Web.Services.Protocols.SoapParameterStyle.Wrapped)]
AN>        public ChangeResponse GetNewData(ChangeRequest changeRequest)
AN>        {
AN>            object[] results = this.Invoke("GetNewData", new object[] {
AN>                        changeRequest});
AN>            return ((ChangeResponse)(results[0]));
AN>        }

AN>

        [System.Web.Services.Protocols.SoapDocumentMethodAttribute("http://rsdn.ru/Janus/PostChange",
         RequestNamespace = "http://rsdn.ru/Janus/", 
         ResponseNamespace = "http://rsdn.ru/Janus/", 
         Use = System.Web.Services.Description.SoapBindingUse.Literal, 
         ParameterStyle = System.Web.Services.Protocols.SoapParameterStyle.Wrapped)]
        public void PostChange(PostRequest postRequest)
        {
            this.Invoke("PostChange", new object[] {
                        postRequest});
        }

I>Добавлю свои 5 копеек. БД сильно чувствительна к фрагментации диска. Винда все таки

DB INSERT INTO [topic_info] 
(
    [mid],
    [gid],
    [answers_count],
    [answers_rate],
    [answers_unread],
    [answers_smile],
    [answers_agree],
    [answers_disagree],
    [answers_me_unread],
    [answers_marked],
    [answers_last_update_date],
    [answers_mod_count],
    [this_rate],
    [this_smile],
    [this_agree],
    [this_disagree],
    [this_mod_count]
)
SELECT
    [m].[mid] as [ID],
    [m].[gid] as [ForumID],
    (
        SELECT
            Count(*)
        FROM
            [messages] [t1]
        WHERE
            [m].[mid] = [t1].[tid]
    ) as [c4],
    (
        SELECT
            Sum([r].[rate] * [r].[rby])
        FROM
            [rating] [r]
                INNER JOIN [messages] [t2] ON [r].[mid] = [t2].[mid]
        WHERE
            [t2].[tid] = [m].[mid] AND [r].[rate] > 0
    ) as [c5],
    (
        SELECT
            Count(*)
        FROM
            [messages] [im]
        WHERE
            [m].[mid] = [im].[tid] AND NOT ([im].[IsRead] = 1)
    ) + CASE
        WHEN [m].[IsRead] = 1 THEN 0
        ELSE 1
    END as [c6],
    (
        SELECT
            Count(*)
        FROM
            [rating] [r1]
                INNER JOIN [messages] [t3] ON [r1].[mid] = [t3].[mid]
        WHERE
            [t3].[tid] = [m].[mid] AND [r1].[rate] = -2
    ) as [c7],
    (
        SELECT
            Count(*)
        FROM
            [rating] [r2]
                INNER JOIN [messages] [t4] ON [r2].[mid] = [t4].[mid]
        WHERE
            [t4].[tid] = [m].[mid] AND [r2].[rate] = -4
    ) as [c8],
    (
        SELECT
            Count(*)
        FROM
            [rating] [r3]
                INNER JOIN [messages] [t5] ON [r3].[mid] = [t5].[mid]
        WHERE
            [t5].[tid] = [m].[mid] AND [r3].[rate] = 0
    ) as [c9],
    (
        SELECT
            Count(*)
        FROM
            [messages] [im1]
                LEFT JOIN [messages] [t6] ON [im1].[pid] = [t6].[mid]
        WHERE
            [m].[mid] = [im1].[tid] AND NOT ([im1].[IsRead] = 1) AND
            [t6].[uid] = @p1
    ) as [c10],
    (
        SELECT
            Count(*)
        FROM
            [messages] [im2]
        WHERE
            [m].[mid] = [im2].[tid] AND [im2].[IsMarked] = 1
    ) as [c11],
    Coalesce((
        SELECT
            Max([t7].[dte])
        FROM
            [messages] [t7]
        WHERE
            [m].[mid] = [t7].[tid]
    ), [m].[dte]) as [c12],
    (
        SELECT
            Count(*)
        FROM
            [moderatorials] [mod1]
                LEFT JOIN [messages] [t8] ON [mod1].[MessageID] = [t8].[mid]
        WHERE
            [t8].[tid] = [m].[mid] AND ([t8].[LastModerated] IS NULL OR [mod1].[Create] > [t8].[LastModerated])
    ) as [c13],
    (
        SELECT
            Sum(Cast([r4].[rate] as SmallInt) * [r4].[rby])
        FROM
            [rating] [r4]
        WHERE
            [m].[mid] = [r4].[mid] AND [r4].[rate] > 0
    ) as [c14],
    (
        SELECT
            Count(*)
        FROM
            [rating] [r5]
        WHERE
            [m].[mid] = [r5].[mid] AND [r5].[rate] = -2
    ) as [c15],
    (
        SELECT
            Count(*)
        FROM
            [rating] [r6]
        WHERE
            [m].[mid] = [r6].[mid] AND [r6].[rate] = -4
    ) as [c16],
    (
        SELECT
            Count(*)
        FROM
            [rating] [r7]
        WHERE
            [m].[mid] = [r7].[mid] AND [r7].[rate] = 0
    ) as [c17],
    CASE
        WHEN [m].[LastModerated] IS NULL
            THEN (
            SELECT
                Count(*)
            FROM
                [moderatorials] [t9]
            WHERE
                [m].[mid] = [t9].[MessageID]
        )
        ELSE (
            SELECT
                Count(*)
            FROM
                [moderatorials] [mod2]
            WHERE
                [m].[mid] = [mod2].[MessageID] AND [mod2].[Create] > [m].[LastModerated]
        )
    END as [c18]
FROM
    [messages] [m]
WHERE
    [m].[tid] = 0 AND [m].[mid] IN (4385578, 4385581)

ACTUAL PERFORMANCE
--------------
ClientConnected:    14:59:48.229
ClientBeginRequest:    14:59:48.230
ClientDoneRequest:    14:59:48.581
Gateway Determination:    0ms
DNS Lookup:         0ms
TCP/IP Connect:        10ms
HTTPS Handshake:    0ms
ServerConnected:    14:59:48.592
FiddlerBeginRequest:    14:59:48.592
ServerGotRequest:    14:59:48.593
ServerBeginResponse:    14:59:48.603
ServerDoneResponse:    14:59:48.623
ClientBeginResponse:    14:59:48.623
ClientDoneResponse:    14:59:48.624

    Overall Elapsed:    00:00:00.3940000