How many articles can a Joomla! website contain?
I stumbled upon some interesting facts about Joomla today (Although I probably knew these things, I had never written them down before). And as I am a little low on blog posts this month I thought I would share these with you.
So, How many articles can a Joomla! website contain?
Believe it or not there is a technical limit to the number of articles (as well as users, categories, sections etc..)
Technical background: All articles are stored in a MySQL database, in a table called jos_contents. Every article has its unique ID, which is stored in the ID field. The ID field is of field type INT(11). The highest number that can be stored in an INT(11) field, and hence the maximum ID that can be used, is 2,147,483,647. So, the maximum number of articles that a Joomla! website can contain is 2,147,483,647.
2,147,483,647 Users
2,147,483,647 Sections
2,147,483,647 Categories
Although I am sure in a real term example the MySQL server would grind to a halt with this size of site unless it was really configured right 
So … how many articles do you have ?
UPDATE: It looks like the original article has now been modified, silly me, the int is unsigned - so that now means 4,294,967,295 (over 4 billion) !!!!
Tags: Joomla Extensions | August 28th, 2008 |
[...] ripresa da Phil Taylor, che si vede che come me segue il wiki di docs.joomla.org, la curiosità è stata [...]
Pingback by I limiti di Joomla, la curiosità del giorno — August 28, 2008 @ 6:41 pm
Sorry about the wrong numbers in your blog post. I got them wrong but thanks to the concept of Wiki, someone else corrected me…
4,294,967,295 is the actual limit because the ID field is NOT of field type INT(11) but INT(11) unsigned.
Comment by Peter Martin — August 28, 2008 @ 9:19 pm
Could u tell me where I can find the database jos_contents. I tried searching for it within my folders but cannot find it. It is called something else.
I have got a lot of articles already written (about 2000 articles or more) and in a Microsoft Access database. i am hoping to somehow transfer this to the Joomla article database without having to type them all in or without have to cut and paste all of them. Please advise where is jos_contents and also if what I am thinking of, will work.
Regards.
Comment by Teh — October 15, 2008 @ 12:23 am