Create separate view for unregistered forum readers?

[szigeti]

I have a custom-designed message board in which unregistered readers can only see posts that are older than a day.

The forum software accesses the posts via a view so the select query is very simple in the application.

Should I create a separate view for the posts that are available for everyone (by defining the required age in the where clause) or should I just add a field which calculates the age of the posts and filter out the immature ones at every select query?

[guelphdad]

neither.

your table currently has a date field right? Check whether the user is logged in or not and then run a query on the whole table and if the user isn't then query based on the older records.