Design adverts in kiosk system

[stockton]

I have been asked to enhance a system running on Windows that would display images for a given length of time one after the other in sequence.

 

The system currently does the necessary display but now the user wants to enhance it with the ability of giving each advert a start and stop datetime. ie Do not display before start date and do not display after stop date.

 

This, of course, is easy to do. The question, however, is do I keep these dates in a text file or in MSSQL and if it is kept in Sequel do I then also keep the image in the same table or leave the image where it currently resides in a folder of images? Next question is, even though the image is the whole page, is there any advantage in using Ajax to switch images?