Forums / Setup & design / Are several thousand locations a problem?

Are several thousand locations a problem?

Previous topic

Setup & design

Next topic

Author	Message
Bertin Hansen	Monday 15 November 2010 4:33:58 am I am working with a large food recipe site and the customers of that site are able to bookmark recipes and organize them in self-made categories ("folders") on their own cooking booke page. The standard bookmark feature does not support categorization so I am planning to use the location feature of eZ Publish to solve this requirement. When the user creates a new category, the code will create a new folder under the customers cooking book node (my own class), and when the customer bookmarks a recipe the code will add a new location to the recipe to that new folder. We will have thousands of users, so a recipe may be located in several thousand locations. Will this be a performence problem? Is this a good idea, or could the requirement be solved in another way? I have rejected the idea of using a object relation list, because I think this would give bad performance when editing the recipe in the Admin GUI.
Bertrand Dunogier	Monday 15 November 2010 5:22:48 am I wouldn't use locations for that. Locations are strongly linked to content cache, and this would really hurt when updating a recipe... Relations might be a way to go, you just have to write a custom UI for it. Pretty much like you wouldn't use the default UI to add locations, would you ? Bertrand Dunogier eZ Systems Engineering, Lyon http://twitter.com/bdunogier http://gplus.to/BertrandDunogier
Gaetano Giunta	Monday 15 November 2010 6:12:10 am Maybe the keyword datatype can also be used with some kind of namespaced keywords? It also has some knobs related to caching that can be of use... Principal Consultant International Business Member of the Community Project Board

Author

Message

Bertin Hansen

Monday 15 November 2010 4:33:58 am

I am working with a large food recipe site and the customers of that site are able to bookmark recipes and organize them in self-made categories ("folders") on their own cooking booke page. The standard bookmark feature does not support categorization so I am planning to use the location feature of eZ Publish to solve this requirement. When the user creates a new category, the code will create a new folder under the customers cooking book node (my own class), and when the customer bookmarks a recipe the code will add a new location to the recipe to that new folder. We will have thousands of users, so a recipe may be located in several thousand locations. Will this be a performence problem? Is this a good idea, or could the requirement be solved in another way? I have rejected the idea of using a object relation list, because I think this would give bad performance when editing the recipe in the Admin GUI.

Bertrand Dunogier

Monday 15 November 2010 5:22:48 am

I wouldn't use locations for that. Locations are strongly linked to content cache, and this would really hurt when updating a recipe...

Relations might be a way to go, you just have to write a custom UI for it. Pretty much like you wouldn't use the default UI to add locations, would you ?

Bertrand Dunogier
eZ Systems Engineering, Lyon
http://twitter.com/bdunogier
http://gplus.to/BertrandDunogier

Gaetano Giunta

Monday 15 November 2010 6:12:10 am

Maybe the keyword datatype can also be used with some kind of namespaced keywords? It also has some knobs related to caching that can be of use...

Principal Consultant International Business
Member of the Community Project Board