seperate databases?

[~phocas~]

This has probly been asked, but I couldn't find it on this board to save my life so.........  In your install instrux, it says...

"It is also recommended that you suse the same database for your board and Coppermine."

Excuse my DB ignorance, but does it really make that much of a difference?  Are there potential issues of having Coppermine use one database and phpBB2 another?  Will they (CPG & phpBB2) run slower?  faster?

The site I will be putting it on, www.phocas.net , is already huge gallery site consisting of about 20,000 photographs so I really am interested in the implications / drawbacks / potential issues of having it on a seperate database than phpBB2.

[~phocas~]

so can nobody answer this question?

[Zarsky]

phocas,

I think it can be done, but most of the current bridge files assume that they are both in the same DB.  A script can only have one DB open at a time, so if they are in different DB's, that the bridge script will have to keep opening and closing the different DB's depending on what is needed at any particular time.  This is neither efficient nor clean coding.  So I think for now just use the same DB with different prefix's.  Why do you need to use seperate DB's?

[~phocas~]

thank you for you respone.  that clarifies a lot.   as far as the need to use seperate DBs?  there's really no need past having the need to be overly organized  :wink:

thanks again...
i very much appreciate it!