I have a large product database - each product is a modx "resource" - I have about 2000 under a landing resource container
When I select the dropdown arrow to display all of my product resources - modx loads for a while but then doesn’t show any resources under my landing resource container.
Things worked fine at about 1,000 resources - but now no go.
System specs - php 5 on centos 5 mysql 5.0.67 community
-
☆ A M B ☆
- 2,475 Posts
Which version of PHP?
Is this a shared host? You might be getting clipped -- often they throttle queries that return large numbers of rows. Do you have access to the MySQL logs? Normal debugging procedure here for suspected slow queries is to turn on the slow query log, restart MySQL and instigate the suspicious queries. On a shared host, you might have to issue ’SET OPTION SQL_BIG_SELECTS = 1’ prior to running your big queries.
Good advice,
I own my own servers I keep my clients on - so I have full control of everything
What do you think the best way to handle it is - A mysql setting in php.ini config that needs to be changed ?
This could be a facet of the tree implementation of modext/extjs, it may not be able to draw that many nodes. I seem to recall splittingred mentioning something about this on another thread, are you getting an JS errors?
Use MODx, or the cat gets it!
-
☆ A M B ☆
- 2,475 Posts
That doesn’t look too bad for mySQL. If I were you, I’d disable InnoDB for now and up the 2 recommended settings:
query_cache_size (>= 8M)
thread_cache_size (start at 4)
Then restart mysqld.
I’d take a look at your PHP memory settings in /etc/php.ini -- how much memory is allocated to PHP. Check your error logs too.
I just looked at a Revo site with ~100k pages, and the poor performance had more to do with the limited amount of RAM available on the machine.
Thanks,
Checking on php.ini settings - I think I’ve maxed them out.
Created a snippet that separates every 1000 products into a "folder" - the tree can handel about 1000ish without flipping out.
-
☆ A M B ☆
- 2,475 Posts
Good thinking. This would make for a fascinating benchmarking article...
-
☆ A M B ☆
- 427 Posts
I recently built a massive website (20 times the topic size) and had content disappearing from manger.
The easy fix: allocate more memory in php.ini.
