Ability to host tables for individual modules in separate databases on separate servers...

Next topic

Author	Message
Stephen Paschall	Thursday 31 July 2003 5:03:22 pm ... especially the User module, since it sees the most traffic on a site that uses user authentication. I'd really like to be able to run a "staging" database server as the master server for "static" content like articles, images, etc., from which content slave db's could replicate data on a set schedule or when forced to do so. I'd like our editors to be the only ones issuing writes to that master db so site traffic doesn't impact the performance of the administrative environment. That can't happen unless I can shift the tables involved in user authentication, forums, etc. to a different server.

Author

Message

Thursday 31 July 2003 5:03:22 pm

... especially the User module, since it sees the most traffic on a site that uses user authentication. I'd really like to be able to run a "staging" database server as the master server for "static" content like articles, images, etc., from which content slave db's could replicate data on a set schedule or when forced to do so. I'd like our editors to be the only ones issuing writes to that master db so site traffic doesn't impact the performance of the administrative environment. That can't happen unless I can shift the tables involved in user authentication, forums, etc. to a different server.

eZ debug

Timing:	Jan 18 2025 04:53:57
Script start
Timing:	Jan 18 2025 04:53:57
Module start 'layout'
Timing:	Jan 18 2025 04:53:57
Module start 'content'
Timing:	Jan 18 2025 04:53:57
Module end 'content'
Timing:	Jan 18 2025 04:53:57
Script end

Main resources:

Total runtime	0.4014 sec
Peak memory usage	4,096.0000 KB
Database Queries	46

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0064	588.4063	152.6875
Module start 'layout'	0.0064	0.0035	741.0938	39.6172
Module start 'content'	0.0099	0.3901	780.7109	400.0313
Module end 'content'	0.3999	0.0014	1,180.7422	8.0156
Script end	0.4013		1,188.7578

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0033	0.8323	16	0.0002
Check MTime	0.0014	0.3433	16	0.0001
Mysql Total
Database connection	0.0012	0.3010	1	0.0012
Mysqli_queries	0.3648	90.8907	46	0.0079
Looping result	0.0004	0.1103	44	0.0000
Template Total	0.3692	92.0	2	0.1846
Template load	0.0020	0.4908	2	0.0010
Template processing	0.3672	91.4986	2	0.1836
Template load and register function	0.0002	0.0416	1	0.0002
states
state_id_array	0.0011	0.2828	1	0.0011
state_identifier_array	0.0007	0.1784	2	0.0004
Override
Cache load	0.0016	0.3875	4	0.0004
Sytem overhead
Fetch class attribute can translate value	0.0005	0.1179	1	0.0005
Fetch class attribute name	0.0007	0.1799	1	0.0007
XML
Image XML parsing	0.0003	0.0738	1	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0012	1	0.0000
General
dbfile	0.0019	0.4835	10	0.0002
String conversion	0.0000	0.0019	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
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.0002 secs