Ez 3.2 and MySql or PostgresSql

Next topic

Author	Message
Tore Skobba	Tuesday 07 October 2003 9:03:03 am Hi all I am working on setting up an new site. Currently I have been working with an MySql database as a backend. But I am thinking about channing to PostGresSql as I think that the advanced functionality in PostGresSql would save me some coding work later on (referential integrity etc.). My question is therefore how stable is Ez on Postgres compared to Ez on MySql? Anyone has any experince with Ez 3.2 on PostGres database they would like to share? Important is eventual bugs, or other things which might lead me to have a longer development time! Secondly why is the Ez Postgres SQL database not using foreign keys? I saw an earlier post asking the same question but with no responses. Cheers Tore
Jeroen van Gorkum	Thursday 09 October 2003 5:02:54 am > why is the Ez Postgres SQL database > not using foreign keys? probably because mysql doesn't support foreign keys. ezp uses database features that are common to both products. jeroen.

Author

Message

Tuesday 07 October 2003 9:03:03 am

Hi all

I am working on setting up an new site. Currently I have been working with an MySql database as a backend. But I am thinking about channing to PostGresSql as I think that the advanced functionality in PostGresSql would save me some coding work later on (referential integrity etc.). My question is therefore how stable is Ez on Postgres compared to Ez on MySql? Anyone has any experince with Ez 3.2 on PostGres database they would like to share? Important is eventual bugs, or other things which might lead me to have a longer development time!

Secondly why is the Ez Postgres SQL database not using foreign keys? I saw an earlier post asking the same question but with no responses.

Cheers
Tore

Jeroen van Gorkum

Thursday 09 October 2003 5:02:54 am

> why is the Ez Postgres SQL database
> not using foreign keys?

probably because mysql doesn't support foreign keys. ezp uses database features that are common to both products.

jeroen.

eZ debug

Timing:	Jan 31 2025 01:29:26
Script start
Timing:	Jan 31 2025 01:29:26
Module start 'layout'
Timing:	Jan 31 2025 01:29:26
Module start 'content'
Timing:	Jan 31 2025 01:29:26
Module end 'content'
Timing:	Jan 31 2025 01:29:26
Script end

Main resources:

Total runtime	0.0245 sec
Peak memory usage	4,096.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0048	588.2500	151.2266
Module start 'layout'	0.0049	0.0038	739.4766	220.7188
Module start 'content'	0.0086	0.0142	960.1953	997.7109
Module end 'content'	0.0228	0.0016	1,957.9063	29.9922
Script end	0.0244		1,987.8984

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0026	10.7904	14	0.0002
Check MTime	0.0011	4.5290	14	0.0001
Mysql Total
Database connection	0.0006	2.6097	1	0.0006
Mysqli_queries	0.0023	9.4914	3	0.0008
Looping result	0.0000	0.0409	1	0.0000
Template Total	0.0012	4.7	1	0.0012
Template load	0.0009	3.7734	1	0.0009
Template processing	0.0002	0.9231	1	0.0002
Override
Cache load	0.0006	2.6097	1	0.0006
General
dbfile	0.0023	9.5070	8	0.0003
String conversion	0.0000	0.0282	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