Access to files and categories is slow

[Zed]

Hi,
When I try to access to files and categories from the control panel , the response is really slow with timeout sometimes . I have checked tables from database and the data are displayed quickly. So the only message that I have is : Count of not authorized file(s): 1. I'm wondering if there is a maximum categories limit because despite the slow-down of files and categories display, the rest seems to work fine.
Thanks for the help
Zed

[Jan]

Hi, how many categories do you have? How many files? What is the value for pagination? Which version of Phoca Download do you use?

Jan

[Zed]

Hi,
We have approximately 3200 categories, 2800 files, 20 for pagination value. When I try to update a categorie I have this message :
Fatal error: Call to undefined method JApplicationHelper::stringURLSafe () : xxxxxx/administrator/components/com_phocadownload/models/phocadownloadcat.php
thanks

[Jan]

Hi, 3200 categoires, I think you need to increase memory, because if you list e.g. 20 or 100 items per pagination, there is no problem but regarding categories, you need to load all of them because to build the tree. So the difference between loading items and categories can be huge because when pagination is used, you only load selected items but you always load all categories (to build the tree)

Which version of Joomla! do you use?

[Zed]

Hi, thanks for your quick response, we use a Joomla! 3.1.1. I can try to increase memory but do you think that it could solved the problem to add or edit files or categories ??
Thanks

[Jan]

You have the list of categories in file list (to filter category) and even in edit of the file (to select the category) so I think, in all cases, loading the complete list of categories takes some memory and slow down the loading of the page.

Jan