[Tutor] design advise

davidwilson at Safe-mail.net davidwilson at Safe-mail.net
Wed Aug 26 13:52:15 CEST 2009


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?

Thanks
Dave


More information about the Tutor mailing list