Seprate Databases

[Pyromanci]

Just a simple question.

I am working on moding SD to invole 2 sperate databases. 1 for SD and the other for the forums. Reason being:

1. The db was reaching is max limit and it was taking out 70% of the database. Our hosting provider has a 100MB cap on the size of a database.
2. With roughlt 5000 hits to our site a day and everything sharing the same Database we were recieving lag and "Unable to Connect to Database" or "To many Connection" errors from the database.

Since this has happend I have had no problems minus the fact the forum and site can no longer be intergrated.

So any one else interested in something like this? If so i will post up the code changes when i get done doing it.

Edit -- I should clear this up a bit. This is for poeple (like me) have a hosting providor that allow only 1 username per database or can not replicate 1 user to have access to another database.

Aswell lets say you have only 1 db from your host. This will allow you to split and use a outside host as well. Not restricting you to have both databases on the same server.

[labrekke]

Eeeh?

Subdreamer already supports that. You can have your forum in one database and Subdreamer in another database. The only thing you have to do is to make sure the database user of Subdreamer has access to the forum database.

[Pyromanci]

Ah, but see that can be a problem. For instance 1&1 hosting or Globat for example have a database system that does not support something like that.

For instance 1&1 allows only 1 user per database. The user name is predefined by their system.

Globat allows multi users to the database but you can't use 1 that has been used in another.

So yes i knew it did the switch, but it did not match some of the systems out there that are being used for web hosting.

[labrekke]

Agreed. That might be a problem for some users. :(

[Pyromanci]

Ok, i have it done and it works fine (for phpBB atleast) i will do the mods to the other forum types and then post up the code changes.

As well this system you guys may want to think about making it a complete change. I mean it just would cover all the possiblities.

(once i finish the core files i will do the plugins that come with SD by defualt. all other you will have to mod on your own.)

[Pyromanci]

Now i remember why i always used phpBB.

Some one want to throw up a copy or variable list for the config files for vb and ipb2 for me?

I can complete everything to have this posted but a few parts of the GetForumSystem() function.