Large queries interfering with Page Rendering
This is an open discussion with 7 replies, filed under Troubleshooting.
Search
sorry will post a screenshot
Maybe it's a PHP and/or webserver max memory setting thing?
Hi David, thanks for your response. I have already adjusted the php.ini just to test and it's still doing the same.
maxexecutiontime = 60
maxinputtime = 60
maxinputvars = 1000
memory_limit = 500M
Do you know if there could there be any other server settings doing this?
Thanks
I've noticed that its happening when the Total Memory Usage
in the Full Page render Statistics
goes beyond 12MB, but I can't work out where this limit is imposed.
Does anyone have an idea?
- PHP memory_limit = 500M
Did you restart PHP (if using FCGI/FPM) and the webserver (e.g., Apache) after changing the PHP settings?
How long does the response take to be returned?
Hi David, thanks for your help. It was strange as the response was taking a few seconds. I finally worked out what was causing it. I had previously added the following line of code in after having some issues with libmxl 2.9.2:
libxml_use_internal_errors(TRUE);
After removing that, the page loaded fine. Problem solved.
Thanks again.
Interesting. I wonder why using that gives rise to that issue.
Glad you figured it out.
Create an account or sign in to comment.
Hi all, excuse me if I can't explain my problem clearly, I have been using Symphony for a good few years but I'm still a bit of a Novice. I have searched the forums but can't find anything like this there so far.
I recently moved a working Symphony site over from a VPS to a dedicated sever and now I'm having a problem when querying larger datasources.
What happens is, for instance when I paginate a particular datasource to say 100 entries, it works fine, but then changing that to 130 (or removing pagination) results in the following
<xsl:choose>
coming out as false. When I check in ?debug though it clearly shows that that it should be true. Because of this it jumps to the<xsl:otherwise>
which as it happens is a log in page.If I change the "test" condition to something like
"1=1"
it comes out as true but then fails to render the linked template (it only renders the master template).So it appears that a larger query is interfereing with the page / templates and or page params.
I really apologise for the vague information. I have been using symphony for some years and have found a lot of help here in the forums, but this one has me stumped!
Any help would be amazing!
Does that Total Memory seem way high or is it just me?
If I need to include any more info, please let me know.
Thanks in advance.