eZ publish datamodel

Next topic

Author	Message
Per-Espen Kindblad	Friday 18 August 2006 1:37:05 am Many people in this forum have asked for a datamodel of eZ publish.. I've made a graphical version of the datamodel (eZ publish 3.7.5). Available at www.eznor.no http://www.eznor.com/index.php/ez/ressurser/ez_publish_datamodell Per-Espen Kindblad
Christian Pfeffer Gjengedal	Wednesday 08 September 2010 4:44:34 am The link is dead, you'll find another diagram at http://ez.no/ezpublish/documentation/reference/database_diagram
Heath	Tuesday 12 October 2010 6:04:46 pm Both links above are dead. Here is an updated one, http://auth.ez.no/ezpublish/documentation/reference/database_diagram Cheers, Heath Brookins Consulting \| http://brookinsconsulting.com/ Certified \| http://auth.ez.no/certification/verify/380350 Solutions \| http://projects.ez.no/users/community/brookins_consulting eZpedia community documentation project \| http://ezpedia.org
Christian Pfeffer Gjengedal	Sunday 02 January 2011 1:08:28 pm Latest schema doc is now available at http://doc.ez.no/eZ-Publish/Technical-manual/4.x/Reference/Database-schema
Doug Brethower	Monday 03 January 2011 11:04:40 am Christian, thank you! That is a quick clean schema review unlike any I had ever seen before. Appears to point toward a great job by db devs on eZ 4.4 version. Has anyone seen results of this schema tool run for other open source CMS? Doug Brethower Apple Certified Technical Consultant, Southwest, MO USA http://share.ez.no/directory/companies/lakedata.net

eZ debug

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0047	588.9063	152.6094
Module start 'layout'	0.0047	0.0020	741.5156	39.4297
Module start 'content'	0.0067	0.9514	780.9453	647.5547
Module end 'content'	0.9581	0.0014	1,428.5000	16.1875
Script end	0.9595		1,444.6875

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0027	0.2847	16	0.0002
Check MTime	0.0012	0.1228	16	0.0001
Mysql Total
Database connection	0.0007	0.0761	1	0.0007
Mysqli_queries	0.9008	93.8774	69	0.0131
Looping result	0.0007	0.0748	67	0.0000
Template Total	0.9346	97.4	2	0.4673
Template load	0.0018	0.1825	2	0.0009
Template processing	0.9329	97.2184	2	0.4664
Template load and register function	0.0001	0.0123	1	0.0001
states
state_id_array	0.0009	0.0899	1	0.0009
state_identifier_array	0.0009	0.0982	2	0.0005
Override
Cache load	0.0015	0.1605	28	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0009	0.0942	4	0.0002
Fetch class attribute name	0.0019	0.2030	9	0.0002
XML
Image XML parsing	0.0046	0.4761	4	0.0011
class_abstraction
Instantiating content class attribute	0.0000	0.0022	10	0.0000
General
dbfile	0.0039	0.4023	34	0.0001
String conversion	0.0000	0.0007	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
5	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
5	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
6	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
2	content/datatype/view/ezxmltags/link.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/link.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 21 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs