Forums / Developer / postgre ves mysql question

postgre ves mysql question

Previous topic

Developer

Next topic

Author	Message
Lior Solomon	Thursday 15 July 2004 1:08:03 am 1. are there any features supported in postgre database then mysql? and vis versa? 2. what is the difference if any in the database scheme between mysql and postgre? 3. if the answer for question 2 is yes, is there an import tool to migrate ez data from postgre to mysql? thanks a lot Lior
Kåre Køhler Høvik	Monday 19 July 2004 1:56:25 am MySQL and PostgreSQL both have some different features, but since eZ publish is cross-platform, we don't utilize them. The SQL syntax is different, but here's an article on how to perform the go from PostgreSQL -> MySQL which might help. http://www.sitepoint.com/article/529 Kåre Høvik

Author

Message

Lior Solomon

Thursday 15 July 2004 1:08:03 am

1. are there any features supported in postgre database then mysql? and vis versa?
2. what is the difference if any in the database scheme between mysql and postgre?
3. if the answer for question 2 is yes, is there an import tool to migrate ez data from postgre to mysql?

thanks a lot

Lior

Kåre Køhler Høvik

Monday 19 July 2004 1:56:25 am

MySQL and PostgreSQL both have some different features, but since eZ publish is cross-platform, we don't utilize them.

The SQL syntax is different, but here's an article on how to perform the go from PostgreSQL -> MySQL which might help. http://www.sitepoint.com/article/529

Kåre Høvik

eZ debug

Timing:

Jan 31 2025 00:40:15

Script start

Timing:

Jan 31 2025 00:40:15

Module start 'content'

Timing:

Jan 31 2025 00:40:15

Module end 'content'

Timing:

Jan 31 2025 00:40:15

Script end

Main resources:

Total runtime

0.2008 sec

Peak memory usage

8,192.0000 KB

Database Queries

141

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0072	587.9297	370.2969
Module start 'content'	0.0072	0.0138	958.2266	1,001.5156
Module end 'content'	0.0210	0.1798	1,959.7422	3,889.8125
Script end	0.2007		5,849.5547

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0072

587.9297

370.2969

Module start 'content'

0.0072

0.0138

958.2266

1,001.5156

Module end 'content'

0.0210

0.1798

1,959.7422

3,889.8125

Script end

0.2007

5,849.5547

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0043	2.1466	20	0.0002
Check MTime	0.0012	0.6193	20	0.0001
Mysql Total
Database connection	0.0007	0.3461	1	0.0007
Mysqli_queries	0.1043	51.9441	141	0.0007
Looping result	0.0014	0.6737	139	0.0000
Template Total	0.1794	89.3	1	0.1794
Template load	0.0008	0.4133	1	0.0008
Template processing	0.1785	88.9095	1	0.1785
Override
Cache load	0.0006	0.2943	1	0.0006
Sytem overhead
Fetch class attribute can translate value	0.0019	0.9363	1	0.0019
XML
Image XML parsing	0.0002	0.1130	1	0.0002
General
dbfile	0.0081	4.0116	20	0.0004
String conversion	0.0000	0.0025	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Accumulator

Duration (sec)

Duration (%)

Count

Average (sec)

Ini load

Load cache

0.0043

2.1466

0.0002

Check MTime

0.0012

0.6193

0.0001

Mysql Total

Database connection

0.0007

0.3461

0.0007

Mysqli_queries

0.1043

51.9441

141

0.0007

Looping result

0.0014

0.6737

139

0.0000

Template Total

0.1794

89.3

0.1794

Template load

0.0008

0.4133

0.0008

Template processing

0.1785

88.9095

0.1785

Override

Cache load

0.0006

0.2943

0.0006

Sytem overhead

Fetch class attribute can translate value

0.0019

0.9363

0.0019

XML

Image XML parsing

0.0002

0.1130

0.0002

General

dbfile

0.0081

4.0116

0.0004

String conversion

0.0000

0.0025

0.0000

Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

Cache	Type	Packlevel	SourceFiles
	CSS	0	extension/community/design/community/stylesheets/ext/jquery.autocomplete.css extension/community_design/design/suncana/stylesheets/scrollbars.css extension/community_design/design/suncana/stylesheets/tabs.css extension/community_design/design/suncana/stylesheets/roadmap.css extension/community_design/design/suncana/stylesheets/content.css extension/community_design/design/suncana/stylesheets/star-rating.css extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css extension/community_design/design/suncana/stylesheets/buttons.css extension/community_design/design/suncana/stylesheets/tweetbox.css extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css extension/sevenx/design/simple/stylesheets/star_rating.css extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css extension/sevenx/design/simple/stylesheets/main.v02.css extension/sevenx/design/simple/stylesheets/main.v02.res.css
	JS	0	extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js extension/community_design/design/suncana/javascript/jquery.ui.core.min.js extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js extension/community_design/design/suncana/javascript/jquery.easing.1.3.js extension/community_design/design/suncana/javascript/jquery.ui.tabs.js extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js extension/community_design/design/suncana/javascript/jquery.popmenu.js extension/community_design/design/suncana/javascript/jScrollPane.js extension/community_design/design/suncana/javascript/jquery.mousewheel.js extension/community_design/design/suncana/javascript/jquery.cycle.all.js extension/sevenx/design/simple/javascript/jquery.scrollTo.js extension/community_design/design/suncana/javascript/jquery.cookie.js extension/community_design/design/suncana/javascript/ezstarrating_jquery.js extension/community_design/design/suncana/javascript/jquery.initboxes.js extension/community_design/design/suncana/javascript/app.js extension/community_design/design/suncana/javascript/twitterwidget.js extension/community_design/design/suncana/javascript/community.js extension/community_design/design/suncana/javascript/roadmap.js extension/community_design/design/suncana/javascript/ez.js extension/community_design/design/suncana/javascript/ezshareevents.js extension/sevenx/design/simple/javascript/main.js

Cache

Type

Packlevel

SourceFiles

CSS

extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css

extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	pagelayout.tpl	<No override>	extension/sevenx/design/simple/templates/pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Usage

Requested template

Template

Template loaded

Edit

Override

pagelayout.tpl

<No override>

extension/sevenx/design/simple/templates/pagelayout.tpl

Number of times templates used: 1
Number of unique templates used: 1

Time used to render debug report: 0.0001 secs