Datamodel documentation

Next topic

Author	Message
Luc Chase	Wednesday 28 March 2007 8:49:16 am Just downloaded 3.9.1 and was looking for a .png image of the whole db schema. Only found multi-language-datamodel.png which only details ten tables. Where can I find the db schema of the entire ezp db schema? The Web Application Service Provider
Kristof Coomans	Wednesday 28 March 2007 10:35:54 am Hi Luc I'm not sure it's a complete, but here's one: http://ez.no/community/forum/general/ez_publish_datamodel independent eZ Publish developer and service provider \| http://blog.coomanskristof.be \| http://ezpedia.org
Luc Chase	Thursday 29 March 2007 8:23:33 am Kristof, thanks but that does not seem to show any relationships, at least not on my screen -- just a large group of tables. The Web Application Service Provider
Kristof Coomans	Thursday 29 March 2007 11:42:00 pm Idd. I think this model was auto-generated from the database, but there are no foreign keys defined in there (because this isn't supported by all eZ-supported DBMS). There's another one out there, it's older but it shows relations: http://ez.no/ezpublish/documentation/reference/database_diagram independent eZ Publish developer and service provider \| http://blog.coomanskristof.be \| http://ezpedia.org
Luc Chase	Friday 30 March 2007 2:38:57 am Thing is, I'm quite sure that in earlier versions of EZP a full schema diagram was always included, but now it seems that only the arear relating to the new multi-lingual features are present. The Web Application Service Provider

eZ debug

Timing:	Jan 19 2025 03:17:24
Script start
Timing:	Jan 19 2025 03:17:24
Module start 'layout'
Timing:	Jan 19 2025 03:17:24
Module start 'content'
Timing:	Jan 19 2025 03:17:24
Module end 'content'
Timing:	Jan 19 2025 03:17:24
Script end

Main resources:

Total runtime	0.6511 sec
Peak memory usage	4,096.0000 KB
Database Queries	63

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0052	589.1250	152.6094
Module start 'layout'	0.0052	0.0032	741.7344	39.4141
Module start 'content'	0.0084	0.6413	781.1484	552.2266
Module end 'content'	0.6498	0.0013	1,333.3750	12.1875
Script end	0.6511		1,345.5625

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0032	0.4871	16	0.0002
Check MTime	0.0013	0.1992	16	0.0001
Mysql Total
Database connection	0.0007	0.1044	1	0.0007
Mysqli_queries	0.6048	92.8911	63	0.0096
Looping result	0.0006	0.0904	61	0.0000
Template Total	0.6225	95.6	2	0.3112
Template load	0.0016	0.2525	2	0.0008
Template processing	0.6208	95.3500	2	0.3104
Template load and register function	0.0001	0.0198	1	0.0001
states
state_id_array	0.0011	0.1645	1	0.0011
state_identifier_array	0.0007	0.1149	2	0.0004
Override
Cache load	0.0015	0.2296	17	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0935	2	0.0003
Fetch class attribute name	0.0011	0.1761	6	0.0002
XML
Image XML parsing	0.0006	0.0941	2	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0021	7	0.0000
General
dbfile	0.0019	0.2861	16	0.0001
String conversion	0.0000	0.0014	4	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	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
5	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
5	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 15 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs