One site - two databases

« 
Previous topic
|
Install & configuration
|
Next topic
 »
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
Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 19 2025 04:38:46
Script start
Timing: Jan 19 2025 04:38:46
Module start 'layout'
Timing: Jan 19 2025 04:38:46
Module start 'content'
Timing: Jan 19 2025 04:38:46
Module end 'content'
Timing: Jan 19 2025 04:38:46
Script end

Main resources:

Total runtime0.6876 sec
Peak memory usage4,096.0000 KB
Database Queries54

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0142 590.2734152.6250
Module start 'layout' 0.01420.0032 742.898439.4609
Module start 'content' 0.01750.6686 782.3594519.6016
Module end 'content' 0.68610.0015 1,301.96098.1641
Script end 0.6875  1,310.1250 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00320.4603160.0002
Check MTime0.00120.1795160.0001
Mysql Total
Database connection0.00110.161610.0011
Mysqli_queries0.635792.4631540.0118
Looping result0.00050.0766520.0000
Template Total0.646494.020.3232
Template load0.00220.318420.0011
Template processing0.644293.691920.3221
Template load and register function0.00010.021110.0001
states
state_id_array0.00080.114010.0008
state_identifier_array0.00090.135720.0005
Override
Cache load0.00180.2602180.0001
Sytem overhead
Fetch class attribute can translate value0.00050.066820.0002
Fetch class attribute name0.00110.165230.0004
XML
Image XML parsing0.00080.120420.0004
class_abstraction
Instantiating content class attribute0.00000.001630.0000
General
dbfile0.00100.1435170.0001
String conversion0.00000.005440.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
2content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
1content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
2content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 8
 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs