Forums / Setup & design / Are several thousand locations a problem?
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
Script start
Module start 'content'
Module end 'content'
Script end
Time used to render debug report: 0.0002 secs