Holidays table front or back end?

[Fred Boer]

Hello:

I've created a "holidays" table for use in a "working days" function. I have
a split database, FE/BE. I understand that sometimes tables are stored with
the FE rather than the BE for reasons of efficiency. I believe a "settings"
table is a typical example (though I could be wrong on that...). Would you
say a "holidays" table would be a candidate for storage in the FE? What kind
of table might you put in the front end? Or would you not do that at all?


Thanks!
Fred Boer

 

[Ken Snell [MVP]]

I'd put a holidays table in the backend.. that way, one update gives
everyone the same data.

Examples of tables that I put in a front end:
User-specific settings
Temporary tables

 

[Fred Boer]

Thanks, Ken! I thought of the updates as an issue, but I use Tony's AutoFE
Updater, and so, updating the FE is perhaps just as easy as updating the BE.
I do understand your point, however. Thanks for other suggestions, too!

Cheers!
Fred