aspose file tools*
The moose likes JForum and the fly likes Limit on the number of users that can subscribe to Jforum installation? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JForum
Bookmark "Limit on the number of users that can subscribe to Jforum installation?" Watch "Limit on the number of users that can subscribe to Jforum installation?" New topic
Author

Limit on the number of users that can subscribe to Jforum installation?

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Re: User Limits:

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]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Limit on the number of users that can subscribe to Jforum installation?
 
Similar Threads
I need serious help with installing this!!
Storing jforum user outside jforum database
JDBC batch statement
Customisation/Feature Request List
Custom backend with different table layout?