What CMS handle handle lots of content?

denvercardonations

Active member
Registered
Joined
Mar 1, 2016
Messages
66
Points
0
My website has been up for 2 months, and I was getting error 508's, SQL errors, PHP timeout errors, etc. After weeks of my webhost blaming Joomla they sent me this:

Hello John,

We do understand your desire to have a website working flawlessly.
That is what we, as the hosting company, are trying to achieve as well.
We are sorry if our previous reply left you under impression that we accusing the CMS you are using of the issues you are currently experiencing.
That was not our intention - what we wanted to do is just describe and explain the logs Oksana has provided in most detailed way to give you full image of how the end-product (i.e. the index page of your site) is being generated.

However, it is true that the size of the database your site's using is far to big.
Let me explain myself further here: MySQL databases, as you may know, are just some amount of text data structured in a relational way, so that it can be easily accessed.
470 Mb of text is just about enough to get half of Library of Congress's books saved under your account (that is rough comparison just to give the idea of text stored under your account now).

We are very sorry that you have been advised to upgrade the hosting account without prior addressing of the root cause of the issue - that is our fault and it is true.
Simply upgrading the account would not get the issue sorted out. Mostly because how MySQL works.
The truth also is that even some of the most powerful dedicated servers will not guarantee the stability of the site in this situation.
What needs to be done is examining the database for duplicate entries - that may explain the time of query execution - for instance in query like this one:

| 827617 | stephbmn_nctest | localhost | stephbmn_step13 | Query | 5001 | Copying to tmp table | SELECT

'5001' is the time in seconds server waited for the query to complete. That is somewhere around 2 hours, whereas standard query on a database with the size of 100-200 Mb is 0.04 - 0.5 seconds

We are only trying to help you to resolve the issue completely.


---------
Regards,
Eugene N.
Level 2 Hosting Customer Support


I have articles, meeting lists, is it really too big? How can this be, I just use the basic CMS functions....
 

Hawker

Well-known member
Registered
Joined
Dec 22, 2015
Messages
287
Points
0
Hi denver could you give us a few more details about your site and the current technology/platform it's running on?

I know it's not WordPress, seems to be some other kind of CMS is it Drupal or Joomla then?

As far as I'm aware, WordPress can handle large databases and sites with lots of content no problem. Especially if its optimised and running on a good hosting plan.

It sounds like your database is rather large. Have you ever optimised it or consulted the help of a MYSQL expert to help you optimise it?

It might be that you can probably loose a large percentage of the 470MB its using without loosing any of your articles, meeting lists etc.

Also, you may very well be able to migrate the site to WordPress which is the leader of all CMS's and might prevent these things happening to you with whatever CMS you're using now.

Just food for thought. :)
 

denvercardonations

Active member
Registered
Joined
Mar 1, 2016
Messages
66
Points
0
Yes it is Joomla, I really didn't think running RSS feeds to content would fill it up so fast, I thought the SQL database would work like a filesystem on a desktop. You know, hold a terabyte of data and be able to do dozens of things all at once, as long as everything is organized! I don't really have so much money to spend hiring an SQL expert. The site is only 2 months old and I was going to index the local meetings since the organizations here do it so poorly. Their meetings are not indexed, it took me forever to actually find reliable information, so instead of the sql query they require, I am making seperate pages per meetings, with tags and pdfs..... *sigh* Maybe this is a little more of a complicated project than I thought.
 

Ron Killian

Well-known member
Registered
Joined
Dec 3, 2015
Messages
363
Points
0
Ya, that seems awful big for a site database. But I don't know much about Joomla. Something doesn't seem right. Would be a very big database for a wordpress site.

If it was me, I would use myPHPAdmin to take a look at the database. You don't have to be an expert at SQL, it's just a tool you can use to work with your database. Most hosting plans, with cpanel offer it.

I say to use this tool because you can browse your database and it shows you the size of each part, row ect.. With it you can at least pin point where most of the space being used. Can show you where there might be a problem.

Even if you convert to Wordpress, you will probably still have the same issue. Doubt migrating is going to make for a smaller database.

If your talking about your donate car denver site, it's not surprising, there are ALOT of entires there. Is it really worth having all that? You might have a ton of content that NEVER gets used or read, could be a huge waste of space.

Just my thoughts.
 

rfharris

Member
Registered
Hosting Provider
Joined
Mar 15, 2016
Messages
52
Points
8
I guess you need to either switch to wordpress or need to change your web host.
 

HostWinds

New member
Registered
Joined
May 23, 2016
Messages
11
Points
0
My website has been up for 2 months, and I was getting error 508's, SQL errors, PHP timeout errors, etc. After weeks of my webhost blaming Joomla they sent me this:

I have articles, meeting lists, is it really too big? How can this be, I just use the basic CMS functions....
Not to be the guy whose like, "ya switch to us". But I do believe that one of our hosting plans would solve your problem. They should be helping to resolve your problem rather than just pawn you off on someone else. It's not Joomla It's something with your hosting provider. We have a hosting plan that has more php memory that would most likely help with your issues.

If you are worried about loosing all your data we also do free site migrations. This way all of your files will transfer without needing to completely start over. If you have questions let me know I'm always on Skype hostwinds.jessej
 

macklong

Active member
Registered
Joined
Jun 17, 2016
Messages
67
Points
0
I'm going with wordpress and joomla. That not means they are my favorites but I love them because they can really host maximum contents. if you taking the wordpress forum system called gravity its also like VB and more better. It's free and available more tools and plugins are also free.

You can google and see there is 100s of free options for backuping from WP and Joomla :) and that's the beauty of it.
 

dewspedjdxm

Member
Registered
Joined
Oct 13, 2016
Messages
26
Points
1
Wordpress is the best platform for Websites with lots of blog content, and they don't gives errors like these. Comes with many plugins and also allows to run forums if you want to expand the community.
 

EpicGlobalWeb

Well-known member
Registered
Joined
Jan 24, 2016
Messages
180
Points
0
Your web host might be more important of a factor than your CMS. There are top 20%ers (traffic) that use Wordpress. Lifehacker used them at one point, probably still do.
 
Older Threads
Replies
8
Views
2,441
Replies
10
Views
3,400
Replies
7
Views
2,859
Replies
2
Views
1,710
Newer Threads
Replies
3
Views
1,792
Replies
2
Views
1,763
MrT
Replies
5
Views
3,118
Recommended Threads

Latest Hosting OffersNew Reviews

Sponsors

Tag Cloud

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top