Forums / Setup & design / mysql & postgresql

mysql & postgresql

Next topic

Author	Message
Alvaro Garcia	Sunday 25 February 2007 3:07:43 am Now i'm using mysql database for the ez but the aplication is too slow. I would like to change the database for postgresql, is better than mysql?. now my mysql postgresql is 23Mb, will I win with the change?. Alvaro

Author

Message

Sunday 25 February 2007 3:07:43 am

Now i'm using mysql database for the ez but the aplication is too slow. I would like to change the database for postgresql, is better than mysql?. now my mysql postgresql is 23Mb, will I win with the change?.
Alvaro

eZ debug

Timing:

Jan 20 2025 12:44:57

Script start

Timing:

Jan 20 2025 12:44:57

Module start 'content'

Timing:

Jan 20 2025 12:44:57

Module end 'content'

Timing:

Jan 20 2025 12:44:58

Script end

Main resources:

Total runtime

0.1880 sec

Peak memory usage

4,096.0000 KB

Database Queries

141

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0061	588.8516	180.8438
Module start 'content'	0.0061	0.0060	769.6953	88.7266
Module end 'content'	0.0120	0.1759	858.4219	517.8750
Script end	0.1880		1,376.2969

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0061

588.8516

180.8438

Module start 'content'

0.0061

0.0060

769.6953

88.7266

Module end 'content'

0.0120

0.1759

858.4219

517.8750

Script end

0.1880

1,376.2969

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0035	1.8623	20	0.0002
Check MTime	0.0013	0.6749	20	0.0001
Mysql Total
Database connection	0.0007	0.3723	1	0.0007
Mysqli_queries	0.1443	76.7735	141	0.0010
Looping result	0.0013	0.6683	139	0.0000
Template Total	0.1755	93.4	1	0.1755
Template load	0.0009	0.4580	1	0.0009
Template processing	0.1747	92.8927	1	0.1747
Override
Cache load	0.0006	0.3234	1	0.0006
Sytem overhead
Fetch class attribute can translate value	0.0010	0.5265	1	0.0010
XML
Image XML parsing	0.0003	0.1505	1	0.0003
General
dbfile	0.0030	1.5851	20	0.0001
String conversion	0.0000	0.0022	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.0035

1.8623

0.0002

Check MTime

0.0013

0.6749

0.0001

Mysql Total

Database connection

0.0007

0.3723

0.0007

Mysqli_queries

0.1443

76.7735

141

0.0010

Looping result

0.0013

0.6683

139

0.0000

Template Total

0.1755

93.4

0.1755

Template load

0.0009

0.4580

0.0009

Template processing

0.1747

92.8927

0.1747

Override

Cache load

0.0006

0.3234

0.0006

Sytem overhead

Fetch class attribute can translate value

0.0010

0.5265

0.0010

XML

Image XML parsing

0.0003

0.1505

0.0003

General

dbfile

0.0030

1.5851

0.0001

String conversion

0.0000

0.0022

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