Details
-
Bug
-
Resolution: Fixed
-
Medium
-
4.2.0
-
None
-
ezflow 2.0
ez 4.2
Description
Hi,
ez 4.2 / ezflow 2.0:
====
At a very large site I try to publish a frontpage with three harmless blocks but I am always getting timeouts.
The reason is: ezflow is producing 142,451 queries
So, after getting the first timeout, I have turned on the sql output to study the queries. In the debug output are "only" 15.000 queries because the timeout came earlier...
Debug output is showing tons of queries like these:
UPDATE ezm_pool
SET ts_visible=1270552511, priority=15547
WHERE block_id='0689a77aba7bdb1b73827202c93dce29'
AND object_id=123697
===
Another strange one:
INSERT INTO ezm_pool(block_id,object_id,node_id,ts_publication) VALUES ('0689a77aba7bdb1b73827202c93dce29',322274,350453,1261050280)
and afterwards (the following query):
SELECT object_id
FROM ezm_pool
WHERE block_id='0689a77aba7bdb1b73827202c93dce29'
AND object_id=322357
LIMIT 0, 1
This query doesn't make sense. But there are like 10.000 queries like these two in the debug output.
Record greetings,
Georg.
Attachments
Issue Links
- relates to
-
EZP-16741 Add possibility to disable time-based operations on publication
- Closed