Federate dbs with ezpublish

Next topic

Author	Message
Pierre Tissot	Friday 05 October 2007 6:09:46 am This is strategy question in order to fallow the best practice and approach to my problem. The aim of this project is to use Ez as a top information system, that will federate several other sources that are Read only information. As a example we have a page that describes some information about Africa, in Ez way (a node, object, etc). Added to this page some other information about Africa will be displayed by asking to other resources outside Ez publish. They are two ways of do this I think. - Import all data to ez publish with a temporary script. - Use Ez to deal with dynamic content and read from the other sources on the fly. In my opinion the second one is the best approach. All the communication with external sources will be manage by function operators that will fecth and fill the displaying templates. Is this a good approach? Somebody has some experience about something like this that can enlighten me, in solutions and performances issues of this problem. thanks Pierre Tissot

Author

Message

Friday 05 October 2007 6:09:46 am

This is strategy question in order to fallow the best practice and approach to my problem.

The aim of this project is to use Ez as a top information system, that will federate several other sources that are Read only information.

As a example we have a page that describes some information about Africa, in Ez way (a node, object, etc). Added to this page some other information about Africa will be displayed by asking to other resources outside Ez publish.

They are two ways of do this I think.
- Import all data to ez publish with a temporary script.
- Use Ez to deal with dynamic content and read from the other sources on the fly.

In my opinion the second one is the best approach. All the communication with external sources will be manage by function operators that will fecth and fill the displaying templates.

Is this a good approach? Somebody has some experience about something like this that can enlighten me, in solutions and performances issues of this problem.

thanks
Pierre Tissot

eZ debug

Timing:	Jan 31 2025 04:21:04
Script start
Timing:	Jan 31 2025 04:21:04
Module start 'layout'
Timing:	Jan 31 2025 04:21:04
Module start 'content'
Timing:	Jan 31 2025 04:21:04
Module end 'content'
Timing:	Jan 31 2025 04:21:04
Script end

Main resources:

Total runtime	0.0145 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0044	588.1250	151.2109
Module start 'layout'	0.0044	0.0024	739.3359	36.6484
Module start 'content'	0.0068	0.0063	775.9844	86.0000
Module end 'content'	0.0131	0.0013	861.9844	29.9922
Script end	0.0145		891.9766

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0023	15.7028	14	0.0002
Check MTime	0.0011	7.3960	14	0.0001
Mysql Total
Database connection	0.0006	4.3646	1	0.0006
Mysqli_queries	0.0021	14.7822	3	0.0007
Looping result	0.0000	0.0690	1	0.0000
Template Total	0.0010	7.1	1	0.0010
Template load	0.0008	5.3987	1	0.0008
Template processing	0.0002	1.6965	1	0.0002
Override
Cache load	0.0005	3.7449	1	0.0005
General
dbfile	0.0024	16.7204	8	0.0003
String conversion	0.0000	0.0411	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	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs