many queries or text file

hi,

say i have a calendar, where for each cell(day) a query is made to check if the day has events on it, if yes it selects the events.

is it better to store the event validation in a text file, like 0 for no 1 for yes, rather than query the database. or it doesn't matter?

thanks

You could consider a different approach. Don't store a value declaring whether there are or are no events on that date. Simply query the database for the events on that date. Then, within your program you will know if there are no events on that date if the number of rows returned is 0.

that's not what i was asking ...

it works and everything, i'm just saying is it better to use the text file to find out if day has events on it and then query the database, rather than query the database for each day.

I know what you were asking. I simply provided an alternative solution. It seems to me you're adding an unnecessary step. You don't need to check if there are events separately from actually getting them. So, my answer would be neither.