[Tutor] design advise

[Kent Johnson]

On Wed, Aug 26, 2009 at 7:52 AM, <davidwilson at safe-mail.net> wrote:
> Hello,
> I would like advise on what method would be better in terms of search and retrieval.
>
> In my application I need to choose how to store data for each user, for example:
>
> /news
> /articles
> /games
>
> My difficulty now comes in how to store this data in that I will need to create views of the data depending on where in the directory the viewer is at for example file:///news/ should contain all the news submitted by all users and file:///games/ should contain all games ...
>
> Also in the file:///users/user/ the user will need access only to their own items, so for example, file:///users/user_1/news/ will list all news added by user_1 etc...
>
> Which is the more efficient option for storing this data, is it better to have all in one place and for each users'
>  view to search by user id and return the filtered down list, or store it within each users' individual directory and then create a new list by traversing each users' directory?

Maybe you should consider storing the data in a database instead of in
the file system? Then it would be easy to retrieve all news, or just
the news for a single user.

Kent