CMS Made Simple Forums

Hi, I've got some problem with Cataloger module. Please help!

Explanation:

I've got site about Airplanes with left menu with structure like this:

----------------------
Airplanes (names):
A-K
L-O
P-Z

Airplanes (indexes):
A
B
C
....

Types:
balloon
militant
gliders
....
----------------------

In Cataloger configuration I've created additional attributes for items:
Index (text)
Type (drop down menu, eg. balloon)

The point is to show 1 airplane by name, by index or by type.

Now I've got in admin backend menu:

All airplanes (sectionheader) - hidden on front page
- airplane 1 (product)
- airplane 2 (product)
- airplane 3 (product)
- ....

where all airplanes are stored.

Than there are pages where Cataloger module is called:

Names
- A-K (content)
- L-O (content)
- P-Z (content)

For egzample in A-K:
{cms_module module='Cataloger' action='all' sub_template='names' alias='All airplanes'}

When I add new airplane I fill up name of the page eg. airplane 1, its index eg. Boing and select its type eg. balloon.

Now, on front page when I choose A-K (name) I've got items:
Airplane 1 - Boing (balloon)
Airplane 2 - ABC (militant)
Airplane 3 - XYZ (militant)
Airplane 4 - XYZ (gliders)
etc.

Now, on front page when I choose index A I've got item:
ABC - Airplane 2 (militant)

in index X:

XYZ - Airplane 3 (militant)
XYZ - Airplane 4 (gliders)

And when I choose for eg. type militant:
Airplane 2 (ABC)
Airplane 3 (XYZ)

Of course these items are all links for description so when I open one there's page about airplane like this:

Airplane 1 (Boing)
Type: balloon
Description: asdasda
+ gallery

---------------------------------
Now the problem is veeery slow generating items in front page because it's not typical structure like Category and Items in it but all Items are in one sectionheader, but on pages I just call Cataloger by name, index or type (displaying depends on category template of course).

The reasone of slow working is I guess when I want to see airplanes by types, Cataloger analyze all Items in db and display only these with attr filled up with for egzample balloon. When I choose names L-O Category template checks if name of airplane starts from L or M or N etc. and displays them.

The problem is I've got for now 2500 items of airplanes.... and displaying ANY PAGE on front or back end (all items are under one sectionheader) takes about 20 secunds and site needs many many MBs of PHP memory to analyze what items have to be displays what way.

Could you please give me same advice how to solve the problem? I now it would work great if I had category Names A-K and Items it this Category starts with A, B...K, than category Names L-N and Items it this Category starts with N, M...O etc., but I have to dispaly products by other attributes too :/

that's a lot of airplanes! i'll let someone else field your real question but have you already done what you can to optimize cmsms and your server? turn up the memory to like 128MB, script time limit, etc. turned on "allow persistent connections"? turned on output compression in config.php? put all your stylesheets together and compress?

Thanks for your answer. Yes, it's all optimized. I turned up the memory to 2048 MB because even 512 MB coused:

Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 264387 bytes) in /public_html/admin/listcontent.php on line 1112

in backend pages list.

$config['output_compression'] and $config['persistent_db_conn'] are set to true.

When I delete {cms_module module='Cataloger'...} page is generating immediately.

i haven't used cataloguer module yet so i probably won't be of any help but you might get more help from those with specific knowledge if you post cmsms version and cataloguer version. but i would think 2500 is not too many. either the module doesn't allow that functionality or there is a different means of implementation. sorry i can't be of more help.