We have created a ASP.NET website to give ticket-based support to our customers. Together with our software, we have given a separate VB6 application where customers can send queries to us, and they can see replies, if any. This application loads the ASP.NET
page inside a Web Browser control. When customers send queries, it will be added to our database; and we send replies to their questions. So ultimately we will be putting replies in a "reply" column of the table.
I want to show replies to customers as soon as we add them. We have set a timer in our support application which checks whether a reply is present in the database. If so, then we show it. We need to check every 5 minutes that any replies are present in the
database. So I think it is what is responsible for more traffic and load on my web server and SQL Server.
Is there any mechanism by which we can trigger the support application which loads the ASP page from the web server? whenever we a ...
Go to the complete details ...