Running two forums, which option is better/quicker??

[AmphetaMarinE]

Sorry if this has been posted before... I tried to search for it, but have no idea exactly what search term to use to find any similar threads....

If I were to run two seperate forums on the same domain, which way would be quicker???

(1) - To use two seperate databases
(2) - To use one database with different table prefixes

Any advice is much appreciated, as I'm still quite new to php & sql

Cheers
Amph.

[Homie]

AH for SMF and YaBB SE i think you should have one database for each forum. I dont think you can share database using two forums you should use 1 database per forum and stuff but also wait for other advise i might be wrong but i think im right.

Hope i helped

Regards
Homie

[David]

It doesn't really matter.  Since they would be in different table sets, since each install would have a different prefix, you wouldn't run into table locking issues.

[[Unknown]]

If you use persistant connections, one database would be better.

-[Unknown]

[AmphetaMarinE]

I am on a shared host, and therefore have not been using persistent connections....
heard somewhere that they are not recommended on shared hosts.

Would I be better enabling persistent connections and using one db?
Or better using the 2 seperate db's and leaving persistent connections disabled?

[[Unknown]]

Yeah - shared hosting, they'd probably be mad if you turned them on.....

It doesn't matter, then.  Whichever you prefer.  Completely preference .

-[Unknown]

[AmphetaMarinE]

OK cool...
Thanks everyone... think i will try with a shared db, and see how it goes...
then i will maybe setup a test board using a seperate db, and import the tables in from the old one... see if performance changes.