Tutorials & articles written by Ivo Lukac

Need for speed - How to use eZ Find search fetch instead of standard content list/tree fetch

This tutorial should give eZ Publish developers some new ideas on how to use eZ Find. The ever growing need for speed can be achieved by using eZ Find search function instead of standard content list/tree fetch functions. Solr engine, used by eZ Find, is far more superior regarding read speed than mysql (at least in the way eZ Publish uses them). This fact becomes apparent when dealing with 10 or 100 thousands of objects in your database with complicated eZ Publish SQL queries starting to slow down rapidly. If you need text search capabilities difference in read speed becomes even more obvious.

eZ debug

Timing:	Jan 18 2025 04:16:46
Script start
Timing:	Jan 18 2025 04:16:46
Module start 'layout'
Timing:	Jan 18 2025 04:16:46
Module start 'community'
Timing:	Jan 18 2025 04:16:47
Module end 'community'
Timing:	Jan 18 2025 04:16:47
Script end

Main resources:

Total runtime	0.0520 sec
Peak memory usage	4,096.0000 KB
Database Queries	24

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0057	589.2188	152.6094
Module start 'layout'	0.0057	0.0028	741.8281	31.6563
Module start 'community'	0.0085	0.0421	773.4844	415.6563
Module end 'community'	0.0507	0.0012	1,189.1406	10.6406
Script end	0.0519		1,199.7813

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0030	5.8662	14	0.0002
Check MTime	0.0014	2.6385	14	0.0001
Mysql Total
Database connection	0.0007	1.2970	1	0.0007
Mysqli_queries	0.0281	54.0289	24	0.0012
Looping result	0.0002	0.4047	21	0.0000
Template Total	0.0353	67.9	2	0.0176
Template load	0.0010	1.9958	2	0.0005
Template processing	0.0342	65.8719	2	0.0171
Template load and register function	0.0001	0.1500	1	0.0001
Override
Cache load	0.0007	1.3181	4	0.0002
states
state_id_array	0.0016	3.0749	1	0.0016
state_identifier_array	0.0008	1.5127	1	0.0008
Sytem overhead
Fetch class attribute name	0.0006	1.1676	1	0.0006
class_abstraction
Instantiating content class attribute	0.0000	0.0156	1	0.0000
General
dbfile	0.0001	0.2886	7	0.0000
String conversion	0.0000	0.0193	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	community/articles.tpl	<No override>	extension/community_design/design/suncana/templates/community/articles.tpl
1	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
1	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 4 Number of unique templates used: 4

Time used to render debug report: 0.0001 secs