locked
return a lot POST requests RRS feed

  • Question

  • User932259438 posted

    Hi,

    I'm facing with issue.

    My code:

    [WebMethod]
        public static IEnumerable<Msg> GetAllMessages()
        {
            var messages = new List<Msg>();
            using (var connection = new SqlConnection(conStr))
            {
                connection.Open();
                using (var command = new SqlCommand(@"SELECT [Message]  FROM [dbo].[DummyData]", connection))
                {
                    command.Notification = null;
    
                    var dependency = new SqlDependency(command);
                    dependency.OnChange += new OnChangeEventHandler(OnDataChange);
    
                    if (connection.State == ConnectionState.Closed)
                        connection.Open();
    
                    var reader = command.ExecuteReader();
    
                    while (reader.Read())
                    {
                        messages.Add(item: new Msg { Message = (string)reader["Message"] });
                    }
                }
            }
    
            return messages;
        }
    public static void OnDataChange(object sender, SqlNotificationEventArgs e)
        {
            if (e.Type == SqlNotificationType.Change)
            {
                NotificationsHub nHub = new NotificationsHub();
                nHub.NotifyAllClients();
                GetAllMessages();
            }
    <script src="Scripts/jquery-2.2.0.min.js"></script>
        <script src="Scripts/jquery.signalR-2.2.0.min.js"></script>
        <script src="signalr/hubs"></script>
    
        <script type="text/javascript">
    
            $(function () {
                var notify = $.connection.notificationsHub;
    
                notify.client.displayNotification = function () {
                    getAllMessages();
                };
    
                $.connection.hub.start();
            });
     function getAllMessages() {
             var tbl = $('#messagesTable');
             $.ajax({
                 url: 'Messages.aspx/GetAllMessages',
                 contentType: 'application/json;utf-8',
                 type: 'POST',
                 dataType: 'json'
             }).done(function (data) {
    
                 tbl.html(data.d)
    
                 // tbl.empty().append(result);
                 // alert("ok");
             }).fail(function (data) {
                 console.log("Failed");
                 console.log(data);
             })
         }

    After update database one row returns more then 50-100 POST requests.

    Like that:

    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 23ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 13ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 1529ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 5566ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 3066ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 519ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 8ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 20ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 2572ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 31ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 39ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 48ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 60ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 69ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 75ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 85ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 81ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 87ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 109ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 117ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 35ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 45ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 56ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 68ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 80ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 82ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 85ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 94ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 92ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 95ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 133ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 133ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 202ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 40ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 57ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 72ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 113ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 129ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 653ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 154ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 166ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 168ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 89ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 87ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 87ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 94ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 107ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 133ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 152ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 159ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 231ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 44ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 53ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 56ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 65ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 69ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 77ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 87ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 97ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 101ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 102ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 108ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 111ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 117ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 143ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 255ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 265ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 25ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 27ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 30ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 32ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 34ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 60ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 73ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 84ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 93ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 620ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 102ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 112ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 124ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 152ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 185ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 265ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 284ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 295ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 304ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 316ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 324ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 333ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 332ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 341ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 195ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 193ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 176ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 183ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 187ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 192ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 197ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 197ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 211ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 221ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 232ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 279ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 317ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 331ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 335ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 337ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 424ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 204ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 186ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 189ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 200ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 219ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 227ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 3779ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 762ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 272ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 279ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 289ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 309ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 357ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 350ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 333ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 210ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 208ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 215ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 221ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 104ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 111ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 121ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 114ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 114ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 114ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 121ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 130ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 135ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 145ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 151ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 147ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 314ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 209ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 227ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 229ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 235ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 243ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 251ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 226ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 229ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 236ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 247ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 269ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 256ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 129ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 115ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 64ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 76ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 153ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 165ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 177ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 185ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 193ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 193ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 194ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 201ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 2706ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 109ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 108ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 109ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 107ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 116ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 116ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 131ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 143ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 142ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 24ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 57ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 70ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 150ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 166ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 180ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 187ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 191ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 193ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 198ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 204ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 213ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 220ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 225ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 232ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 239ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 101ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 118ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 25ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 35ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 59ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 73ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 148ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 151ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 164ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 175ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 181ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 187ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 207ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 213ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 213ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 216ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 220ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 225ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 139ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 137ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 147ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 147ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 152ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 182ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 710ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 447ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 460ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 476ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 225ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 238ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 253ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 262ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 272ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 281ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 287ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 296ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 300ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 312ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 321ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 336ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 349ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 363ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 371ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 379ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 400ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 415ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 450ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 470ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 476ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 476ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 477ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 485ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 464ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 466ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 475ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 484ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 2034ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 505ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 514ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 526ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 537ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 364ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 375ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 385ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 1928ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 415ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 429ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 439ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 458ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 434ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 459ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 480ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 493ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 619ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 659ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 653ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 623ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 604ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 598ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 338ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 339ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 345ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 351ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 360ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 366ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 374ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 381ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 391ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 400ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 409ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 416ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 422ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 434ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 444ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 445ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 456ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 464ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 536ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 542ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 548ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 569ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 569ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 564ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 480ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 311ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 280ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 286ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 282ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 293ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 300ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 309ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 368ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 375ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 361ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 367ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 377ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 396ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 409ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 422ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 429ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 437ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 444ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 452ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 461ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 470ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 475ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 482ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 486ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 471ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 478ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 485ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 496ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 498ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 504ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 506ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 524ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 538ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 546ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 548ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 398ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 419ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 412ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 398ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 544ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 577ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 598ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 605ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 616ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 627ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 636ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 647ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 656ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 664ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 671ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 656ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 664ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 672ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 681ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 687ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 699ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 707ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 719ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 729ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 736ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 746ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 756ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 765ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 787ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 796ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 807ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 829ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 846ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 852ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 857ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 867ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 872ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 884ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 889ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 894ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 675ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 672ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 667ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 661ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 802ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 792ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 788ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 792ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 775ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 775ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 782ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 790ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 799ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 803ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 807ms]
    POSTXHR
    http://localhost:30685/Messages.aspx/GetAllMessages
    [HTTP/1.1 200 OK 830ms]

    Tuesday, January 2, 2018 8:45 PM

Answers

  • User475983607 posted

    I'm guessing (pretty sure though) that you created a memory leak due to creating new SqlDependency every time GetAllMessages is called.  Look into creating a singleton to hold the dependency or use a cache to hold the result set (which I suggested in another thread). 

    Anyway, I did a Google search and found the following tutorial which I lightly browsed but it seems like it is what you are trying to do in Web Forms.  Hopefully, it works for you.  

    https://www.codeproject.com/Articles/1029976/SQL-Server-Notifications-on-Record-Change-with-Sig

    If there are parts you do not understand try read the docs.  If you get completely stuck, post your question but include enough information so we know what what you're doing.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, January 2, 2018 10:00 PM
  • User61956409 posted

    Hi progy85,

    progy85

    NotificationsHub nHub = new NotificationsHub();
    nHub.NotifyAllClients();
    GetAllMessages();

    In your code, I can find that you call both nHub.NotifyAllClients() and GetAllMessages() in your SqlDependency OnChange Event, and your JavaScript function displayNotification will be executed and JavaScript function getAllMessages also be executed to make request to Messages.aspx/GetAllMessages.

    With Regards,

    Fei Han

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, January 3, 2018 2:51 AM

All replies

  • User475983607 posted

    I'm guessing (pretty sure though) that you created a memory leak due to creating new SqlDependency every time GetAllMessages is called.  Look into creating a singleton to hold the dependency or use a cache to hold the result set (which I suggested in another thread). 

    Anyway, I did a Google search and found the following tutorial which I lightly browsed but it seems like it is what you are trying to do in Web Forms.  Hopefully, it works for you.  

    https://www.codeproject.com/Articles/1029976/SQL-Server-Notifications-on-Record-Change-with-Sig

    If there are parts you do not understand try read the docs.  If you get completely stuck, post your question but include enough information so we know what what you're doing.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, January 2, 2018 10:00 PM
  • User61956409 posted

    Hi progy85,

    progy85

    NotificationsHub nHub = new NotificationsHub();
    nHub.NotifyAllClients();
    GetAllMessages();

    In your code, I can find that you call both nHub.NotifyAllClients() and GetAllMessages() in your SqlDependency OnChange Event, and your JavaScript function displayNotification will be executed and JavaScript function getAllMessages also be executed to make request to Messages.aspx/GetAllMessages.

    With Regards,

    Fei Han

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, January 3, 2018 2:51 AM