This topic contains 2 replies, has 1 voice, and was last updated by Dean 2 years, 10 months ago.
- April 30, 2014 at 06:32 #1757
Is the any kind of restriction on the database when creating categories? limited or unlimited?April 30, 2014 at 07:03 #1768
Theoretically there is no limit in number of locations and categories. In reality categories and locations are read once and kept in memory, because they are used in many places several times. Loading all to memory also reduces database load. So if you keep your locations below 1000 or 2000 (one or two thousand) and categories also below that limit it works fine.
There is no limit in depth of sublocations and subcategories. You can go 20-30 levels down if you want. Note that your breadcrumbs may look very crowded in case you use too many levels.
Read more about location and category memory usage and limits here http://classibase.com/forums/topic/bug-15000-locations/#post-1653
Also we use number 50K limit for location with category combination. 50K can be 1K locations and 50 categories or can be 500 locations and 100 categories etc. So if number_of_locations X number_of_categories > than 50.000 then ad count is not generated for keeping your site fast. Because all 50K records loaded to memory to calculate ads in main categories including counts in subcategories. You can read more about tests with ad counting and how to disable it here http://classibase.com/classibase-version-1-4-4-released/#disable_ad_countApril 30, 2014 at 08:49 #1777