Forums / Developer / Newbie - before choosing right CMS solution.....

Newbie - before choosing right CMS solution.....

Next topic

Author	Message
Aleksander Lech	Sunday 14 August 2005 12:47:31 am Hi there! I'm trying to make decission about choosing right CMS solution for my company's client. ezPublish looks pretty cool, but I have now one question. Is there possibility to make db queries in "PHP way" - I mean - in some php file I have script line which connects me to the db, than I have an SQL query, which (when executed) stores the result in some resultset variable. I can then use the result in the way I want. Can I do this in ezPublish the same way or do I have to create classes, objects etc. I'd never had to use php classes and objects before :( And after long hours of ezp forum reading, I'm confused a little. Greetings Aleksander
Gabriel Ambuehl	Sunday 14 August 2005 2:21:56 am You will likely not need to define your own SQL for most tasks. If you need to, you'll most likely have to write an extension (possibly template operator) and that does need PHP knowledge. Visit http://triligon.org
Aleksander Lech	Sunday 14 August 2005 3:59:19 am Well, most likely I will need to define my own SQL queries, because there will be a lot of non-ezPublish tables which I'll have to search. So probably there's no easy way to incorporate custom php scripts and pass their results to ezP templates? I know, that I can create extension/module but - according to this: http://ez.no/products/ez_publish_cms/documentation/development/extensions/module/module_tutorial_part_1 do I really need to create such complicated structure and fuctions to extract data from non-ezP tables? Greetings Aleksander
Gabriel Ambuehl	Sunday 14 August 2005 4:25:10 am If you need custom databases, it's probably necessary, yes. Visit http://triligon.org
Aleksander Lech	Sunday 14 August 2005 4:45:02 am Thank you very much Gabriel for ypur quick responses. I'll start learning ezP soon then. Aleksander
Bruce Morrison	Sunday 14 August 2005 2:51:39 pm Hi Aleksander I know, that I can create extension/module but - according to this: http://ez.no/products/ez_publish_...nsions/module/module_tutorial_part_1 do I really need to create such complicated structure and fuctions to extract data from non-ezP tables? While it may seem complicated once you get your head around it you will find that most of the functions you require are provided by eZ. Also look at the eZPersistentObject class http://pubsvn.ez.no/doxygen/classeZPersistentObject.html Cheers Bruce My Blog: http://www.stuffandcontent.com/ Follow me on twitter: http://twitter.com/brucemorrison Consolidated eZ Publish Feed : http://friendfeed.com/rooms/ez-publish
Gabriel Ambuehl	Sunday 14 August 2005 3:07:52 pm The fact that functions are provided by eZ doesn't necessarily mean it's easier. In some case one could truly argue it to be much harder if you try to use the integrated API as opposed to just firing SQL against the DB... Visit http://triligon.org
Bruce Morrison	Sunday 14 August 2005 5:00:05 pm Hi Gabriel The fact that functions are provided by eZ doesn't necessarily mean it's easier. In some case one could truly argue it to be much harder if you try to use the integrated API as opposed to just firing SQL against the DB... Sure and sometimes you have to do that. It all depends on what you need to do and how complex that database structure is. What I was pointing out is that the eZ framework provides a lot of functionality that if used can save a lot of time. It may seem complicated on the surface but once you get used to using it, it can be quite simple. See paragraph 1 ;) Cheers Bruce My Blog: http://www.stuffandcontent.com/ Follow me on twitter: http://twitter.com/brucemorrison Consolidated eZ Publish Feed : http://friendfeed.com/rooms/ez-publish

Timing:	Jan 18 2025 21:14:46
Script start
Timing:	Jan 18 2025 21:14:46
Module start 'content'
Timing:	Jan 18 2025 21:14:48
Module end 'content'
Timing:	Jan 18 2025 21:14:48
Script end

Total runtime	1.4294 sec
Peak memory usage	4,096.0000 KB
Database Queries	75

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0073	587.8438	180.8125
Module start 'content'	0.0073	1.4160	768.6563	634.7656
Module end 'content'	1.4233	0.0061	1,403.4219	50.0703
Script end	1.4293		1,453.4922

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	0.2181	14	0.0002
Check MTime	0.0013	0.0889	14	0.0001
Mysql Total
Database connection	0.0010	0.0689	1	0.0010
Mysqli_queries	1.3690	95.7731	75	0.0183
Looping result	0.0009	0.0612	73	0.0000
Template Total	1.3856	96.9	2	0.6928
Template load	0.0020	0.1390	2	0.0010
Template processing	1.3836	96.7982	2	0.6918
Template load and register function	0.0002	0.0111	1	0.0002
states
state_id_array	0.0010	0.0677	1	0.0010
state_identifier_array	0.0023	0.1608	2	0.0011
Override
Cache load	0.0018	0.1233	44	0.0000
Sytem overhead
Fetch class attribute can translate value	0.0019	0.1363	3	0.0006
Fetch class attribute name	0.0017	0.1197	9	0.0002
XML
Image XML parsing	0.0008	0.0553	3	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0019	10	0.0000
General
dbfile	0.0013	0.0885	18	0.0001
String conversion	0.0000	0.0004	3	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
8	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
16	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
7	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
2	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	pagelayout.tpl	<No override>	extension/sevenx/design/simple/templates/pagelayout.tpl
Number of times templates used: 37 Number of unique templates used: 7

Newbie - before choosing right CMS solution.....

eZ debug

Main resources:

Timing points:

Time accumulators:

Templates used to render the page: