No Spam.
We try to educate our posters all day to mantain posts clear and usefull...

I don't know how to resolve this problem...maybe the best solution is to hack the modules...or talk with my provider...

Quote:
Newbb forum and other module...I have just analyze and optimize tables...

Quote:
I think this is not a problem, my provider have a cluster of server in theory.

Quote:
Yes, the real problem is that just one or two module "block" the access to the database and take up space limit.

@dbman
Wow, it can solve my question...
but:
Quote:

@ghia
I have got a big database, my provider gives me a limit to my database but I can use another database with the same limit (for example 100Mb per databases, I can have 2 databases = 200Mb, but not only one database with 200Mb ok?)
Some time I have got slow query execution or db connection faild because I have too much users connect at the same time.
So I think to use two or more database, this give me these benefits:
- not too multiple access at the same time with different query at one database, the access or load are distributed to multiple databases; (but this benefit is not real with federated engine isn't?);
- more order in database, not only one database with a hundred of tables but two or more databases with a few tables to mantain.

Is it stupid?
Are there other solutions?

Thank you for your replay.

@ mariane
No, I work with only one website.
I can create different MySQL databases on my server. I want store data of a module in a different database, so for example I have two database, the first contain table and data of XOOPS "core" and varius modules, the second database store data of only one module (in my previous example newbb).

@xsell
I suppose that...to overwrite the problem to hack modules or write php code I think that:
Quote:
but I don't know really much these tecnology...
Can't I order to MySql to save all data that are insert in one table (with a generic query) in another table present on a different database?

I hope you can understand me...

Hy, I'm new, I'm Italian so excuse me for my bad english...

I have got this question:
Is it possible to store data of one module in a different MySQL database than the database use from XOOPS core?

For example I have XOOPS 2.4.3, I have installed newbb module to create a forum, can I store all data of newbb (or another module) in a second database?

I think 2 solutions:
1) hack the module,
2) try to use MySQL Engine MERGE, but I don't think is the best solution...

Have you got any ideas?

Thank you