Are several thousand locations a problem?

Monday 15 November 2010 4:33:09 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.