Dear fellow programmers:
I have the following: 2 asp.net (C#) apps, both of them 3-tiers apps, UI, Business Logic, and the DataAccess of both of them call the same webservice.
The apps are used on a classroom setting; one app is used to only log stuff to the database, students answering to multiple choice questions; the other app, is the teacher app, that only need to read those answers and see how many students choose option A, how many B, etc..
The challenge is that both apps run at the same time, so... the teacher needs to see live how the students are responding to the questions.
What I have so far is an AJAX timer that calls the BL layer, DA layer, WebService, every second checking the database, and it works fine. But my concern is that I am accessing this database too much, it is a hosted MySQL database (not in house), the app and web service also hosted with the same company, so the teacher just goes to one website, stundents go to other one an ...
Go to the complete details ...