In the News
Keep up to date on all of my projects, research, and random thoughts...
Torture testing the system
September 5, 2008
I have gotten a lot of questions from people about just how large a site the Digitalus Site Manager can handle.
This is a reasonable concern...usually flexibility and ease of use come at the expense of performance and scaleability. So I had a lazy Sunday morning to burn, and decided to see exactly how well the system does perform with a large site.
Setting up the testing database
I started by creating 10 folders. I added 10 folders in each and so on until I had 110,000 pages +/-. I inserted 200 words in each page. Don't try this at home! It would take 2.5 years for the average good typist.
So here are the stats:
- 110, 000 pages
- about 22,000,000 words
- pages nested 5 levels deep
The results
I then went to the deepest darkest corner of the database:
- Home
- Folder 10
- Folder 10
- Folder 10
- Folder 10
- Page 10
- Folder 10
- Folder 10
- Folder 10
- Folder 10
The page took 0.74 seconds to load the first time. Please keep in mind that the Digitalus Site Manager also includes advanced page caching (much thanks to Zend Cache) which is enabled by default. This saves the HTML page that the CMS generated in a certain kind of text file, so the database does not need to rebuild it each time. The second time I loaded the page it took 0.019 seconds to load!*
Other tests
100,000 page sites are fairly rare, but 5-10,000 pages are pretty common once a site has grown for a number of years with multiple contributors. The difference between this site loading its 150 +/- pages and a test site loading 10,000 was unnoticable.
*note that I performed all of these test utilizing the Zend Db Profiler.
