Forums / Install & configuration / One site - two databases

One site - two databases

Author Message

Ruben Torres

Thursday 26 February 2004 5:39:39 pm

Hello,
I'm using eZ 3.3 with postgresql. The site I'm developing must have two databases,
one for the information of registered users and one for new users. Is it posible
for me to have this database configuration for one site?
I was thinking on having the eZ publish database integrated with one of the group of
tables I need and a separated database for the other group of tables. But I don't if
this is possible.

Any help would be appreciated.

Regards,

Rubén

Jan Borsodi

Tuesday 02 March 2004 6:48:22 am

eZ publish requires all tables (and data) to be in the same database. Separating them createa lots of interesting technical problems.

You could have one database with user information (e.g. in LDAP) and synchronize it with the external user login system (currently only LDAP).

Is there a special reason you need them separated?

--
Amos

Documentation: http://ez.no/ez_publish/documentation
FAQ: http://ez.no/ez_publish/documentation/faq

eZ debug

Timing: Jan 30 2025 21:45:02
Script start
Timing: Jan 30 2025 21:45:02
Module start 'content'
Timing: Jan 30 2025 21:45:02
Module end 'content'
Timing: Jan 30 2025 21:45:03
Script end

Main resources:

Total runtime0.3179 sec
Peak memory usage8,192.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0067 587.9453370.2969
Module start 'content' 0.00670.0135 958.24221,001.5469
Module end 'content' 0.02020.2976 1,959.78913,890.4688
Script end 0.3178  5,850.2578 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00461.4530200.0002
Check MTime0.00140.4446200.0001
Mysql Total
Database connection0.00060.195710.0006
Mysqli_queries0.219068.90791410.0016
Looping result0.00160.49561390.0000
Template Total0.297193.510.2971
Template load0.00090.271810.0009
Template processing0.296293.196410.2962
Override
Cache load0.00060.185910.0006
Sytem overhead
Fetch class attribute can translate value0.00200.634010.0020
XML
Image XML parsing0.00030.082710.0003
General
dbfile0.00491.5498200.0002
String conversion0.00000.002030.0000
Note: percentages do not add up to 100% because some accumulators overlap

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

CacheTypePacklevelSourceFiles
CSS0extension/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
JS0extension/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:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0003 secs