Hi, I would like to know whether there is any limit imposed on the number of users that can subscribe to the JForum? I do realize that this limit might depend on the hardware that can support large base of users. But does the software too is limited by the number of registered users or the number of active users?
Also, I am working on a product with which JForum can be integrated. I would appreciate if someone could confirm that I can make 10 different installations of JForum which use the same database installation.
Lastly, I would appreciate if someone could point me to the database table details for JForum.
Thanks for the reply.
Regards. [originally posted on jforum.net by aman]
AFAIK, the software limit is based on how many unique keys you can have in the user table. This is dependent on your DB and method of creating them. E.g., MySQL's autoincrement fields with a normal unsigned integer have a limit of 4294967295 entries. I think you'll hit hardware limits before then.
Re: Same DB installation
As long as each jForum installation has it's own "Schema" for tables, you can use a single DB server. E.g., in MySQl, each installation would have it's own Catalog / Database and the jForum installation's JDBC URL would point to that.
Re: Database Documentation
The tables are fairly well self documenting. I think there is an images somewhere in the source repository that lays it out. But for the most part if you just start looking at the table layout, it's pretty obvious. The column naming is consistent across tables so if something says:
user_id, then you know it's the user_id key field, and the like.
For the 2.1 series, you can also look at the data access object interfaces and your DB specific implementation to see how the jForum entity objects get translated to and from the DB. [originally posted on jforum.net by monroe]
Thanks for the reply, Monroe.
I can now understand the queries 1 and 3, I posted. I am still not 100% clear on the 2nd query I posted. Please let me reframe this.
I have main application X and I have jForum installation. Is it possible that I somehow merge the database for JForum installation with that for the main application. I have still not decided to go forward in this direction but I would like to know about this, if possible.
And secondly, as I mentioned in my last post, if I keep the databases separate, can this be done that I install the Jforum application on 10 different machines and each of these machines use the same database? I see from your reply that this can be done. We only need to point to this particular database server installation. Please confirm.
Thanks for assistance.
[originally posted on jforum.net by aman]
Create symphonies in seed and soil. For this tiny ad: