SitePoint Sponsor

User Tag List

Results 1 to 12 of 12
  1. #1
    SitePoint Addict Shaydez's Avatar
    Join Date
    Jul 2006
    Location
    Boca Raton, Florida
    Posts
    356
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    I just can't believe wordpress

    Seriously.. I can't believe Wordpress is popular. The more I'm disappointed with the wordpress developers. Its poorly developed.

    Just today i found out they're storing all the url-rewrites in the database under wp_option [url-rewrites] all the URL rewrites are in JSON encode. I have a client that has a 60MB ROW! not table.. ROW. LoL!

    I couldn't believe my eyes.. so I thought this has to be one of those ****** plugins. So i took a look at a basic wordpress site i installed and behold RULES in the database

    I have a rule with storing JSON in a row, i try to keep it less than 500kb and that's alot. If there's any chance JSON needs to grow more than that, tells any database engineer ' HMM... Maybe it needs its own table.'


    the following is half of a basic wordpress installation
    a:68:{s:47:"category/(.+?)/feed/(feed|rdf|rss|rss2|atom)/?$";s:52:"index.php?category_name=$matches[1]&feed=$matches[2]";s:42:"category/(.+?)/(feed|rdf|rss|rss2|atom)/?$";s:52:"index.php?category_name=$matches[1]&feed=$matches[2]";s:35:"category/(.+?)/page/?([0-9]{1,})/?$";s:53:"index.php?category_name=$matches[1]&paged=$matches[2]";s:17:"category/(.+?)/?$";s:35:"index.php?category_name=$matches[1]";s:44:"tag/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$";s:42:"index.php?tag=$matches[1]&feed=$matches[2]";s:39:"tag/([^/]+)/(feed|rdf|rss|rss2|atom)/?$";s:42:"index.php?tag=$matches[1]&feed=$matches[2]";s:32:"tag/([^/]+)/page/?([0-9]{1,})/?$";s:43:"index.php?tag=$matches[1]&paged=$matches[2]";s:14:"tag/([^/]+)/?$";s:25:"index.php?tag=$matches[1]";s:45:"type/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$";s:50:"index.php?post_format=$matches[1]&feed=$matches[2]";s:40:"type/([^/]+)/(feed|rdf|rss|rss2|atom)/?$";s:50:"index.php?post_format=$matches[1]&feed=$matches[2]";s:33:"type/([^/]+)/page/?([0-9]{1,})/?$";s:51:"index.php?post_format=$matches[1]&paged=$matches[2]";s:15:"type/([^/]+)/?$";s:33:"index.php?post_format=$matches[1]";s:48:".*wp-(atom|rdf|rss|rss2|feed|commentsrss2)\.php$";s:18:"index.php?feed=old";s:20:".*wp-app\.php(/.*)?$";s:19:"index.php?error=403";s:18:".*wp-register.php$";s:23:"index.php?register=true";s:32:"feed/(feed|rdf|rss|rss2|atom)/?$";s:27:"index.php?&feed=$matches[1]";s:27:"(feed|rdf|rss|rss2|atom)/?$";s:27:"index.php?&feed=$matches[1]";s:20:"page/?([0-9]{1,})/?$";s:28:"index.php?&paged=$matches[1]";s:27:"comment-page-([0-9]{1,})/?$";s:38:"index.php?&page_id=8&cpage=$matches[1]";s:41:"comments/feed/(feed|rdf|rss|rss2|atom)/?$";s:42:"index.php?&feed=$matches[1]&withcomments=1";s:36:"comments/(feed|rdf|rss|rss2|atom)/?$";s:42:"index.php?&feed=$matches[1]&withcomments=1";s:44:"search/(.+)/feed/(feed|rdf|rss|rss2|atom)/?$";s:40:"index.php?s=$matches[1]&feed=$matches[2]";s:39:"search/(.+)/(feed|rdf|rss|rss2|atom)/?$";s:40:"index.php?s=$matches[1]&feed=$matches[2]";s:32:"search/(.+)/page/?([0-9]{1,})/?$";s:41:"index.php?s=$matches[1]&paged=$matches[2]";s:14:"search/(.+)/?$";s:23:"index.php?s=$matches[1]";s:47:"author/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$";s:50:"index.php?author_name=$matches[1]&feed=$matches[2]";s:42:"author/([^/]+)/(feed|rdf|rss|rss2|atom)/?$";s:50:"index.php?author_name=$matches[1]&feed=$matches[2]";s:35:"author/([^/]+)/page/?([0-9]{1,})/?$";s:51:"index.php?author_name=$matches[1]&paged=$matches[2]";s:17:"author/([^/]+)/?$";s:33:"index.php?author_name=$matches[1]";s:69:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/feed/(feed|rdf|rss|rss2|atom)/?$";s:80:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&feed=$matches[4]";s:64:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/(feed|rdf|rss|rss2|atom)/?$";s:80:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&feed=$matches[4]";s:57:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/page/?([0-9]{1,})/?$";s:81:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&paged=$matches[4]";s:39:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/?$";s:63:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]";s:56:"([0-9]{4})/([0-9]{1,2})


    This URL rewrite is just 1 of 50 other things i found really pathetic about wordpress.
    Sr. Website Developer and Internet Marketing
    www.CarlosJa.com Note: If anyone
    needs to get ahold of me please feel free to email me through
    my site. Apparently i missed quite a few private messages.

  2. #2
    SitePoint Wizard bronze trophy
    Join Date
    Jul 2006
    Location
    Augusta, Georgia, United States
    Posts
    4,151
    Mentioned
    16 Post(s)
    Tagged
    3 Thread(s)
    It isn't uncommon for major content management systems and contributed code to store data in a serialized form. I work with Drupal and the same thing is done for very complex entities where it really be isn't practical to have a normalized structure. It still is wrong from a database architecture point of view but in some cases I can understand it. Though I'm not sure if this qualifies as one of those cases. I hate wordpress as well.
    The only code I hate more than my own is everyone else's.

  3. #3
    SitePoint Wizard TheRedDevil's Avatar
    Join Date
    Sep 2004
    Location
    Norway
    Posts
    1,196
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Shaydez View Post
    Seriously.. I can't believe Wordpress is popular. The more I'm disappointed with the wordpress developers. Its poorly developed.
    WordPress show the major issue we have using PHP, that the average skill level for PHP programmers is quite poor. Which makes it harder to get into enterprise projects.

    We ran a multisite installation of WordPress for a client a while ago with 200k+ active blogs, and to archive that we had to rewrite all of the plugins they wanted to add + several sections of the core WP code. (+ of course a larger server cluster). Luckily that is now over on a custom solution that does the same as WP did and more, but require a lot less servers to handle the load.

    Quote Originally Posted by Shaydez View Post
    I have a rule with storing JSON in a row, i try to keep it less than 500kb and that's alot. If there's any chance JSON needs to grow more than that, tells any database engineer ' HMM... Maybe it needs its own table.'
    You might want to reduce that even more, depending on the way it is accessed. As if that row is pulled at a high frequency (high load) from the DB that could effectively kill your bandwidth. This is mainly an issue if the cache layer fails (assuming the data is cached on the server level as well, if not it is a high traffic issue), which they sometimes does and just one failure like that can cost hundred thousands of dollars if your client has a promotion going for example.

  4. #4
    SitePoint Enthusiast Soapmarine's Avatar
    Join Date
    Dec 2013
    Location
    Belgium
    Posts
    67
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    In my opinion, Wordpress is convenient and perfect for a small business or new business with young entrepreneurs. It gives possibility to quickly develop a website that finished and runs, easy to maintain by the business owner without a big risk to ruin it and to stay in shoe-string budget for the whole site. And keep money for promotion.

    I have people who come to me and they have $600 for the A-Z finished website, they need CMS, about, blog, contact, tweet widget, home slider with 5 customised images and portfolio section or shop. They dont have more money! They pay some extra for the images and they buy themselves the domain and hosting plan.
    They dont want to go on freelance websites and pick up somebody cheap there because they need me on phone when they delete a page.

    Of course, Wordpress it's not a Ferrari. But some people need a car to go to work and they buy Opel and happy with German quality.

  5. #5
    SitePoint Zealot bronze trophy xMog's Avatar
    Join Date
    Mar 2011
    Posts
    148
    Mentioned
    3 Post(s)
    Tagged
    1 Thread(s)
    Each time I press the upgrade button on my blog, my heart rate goes up. Even if I have a local copy of it, I just can't trust it.
    I spent probably 1-2 hours yesterday trying to fix opt-in skin. Uninstalling it didn't really uninstalled it, there was still crappy data somewhere in the database. I just switched to another temporary solution until I get more time to fix it.
    But, well.. you can still set-up an OK website in 2-3 hours, choose from thousands of different themes and plug-ins. And it works. Just don't look at the generated HTML though.

  6. #6
    SitePoint Enthusiast Soapmarine's Avatar
    Join Date
    Dec 2013
    Location
    Belgium
    Posts
    67
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by xMog View Post
    Each time I press the upgrade button on my blog, my heart rate goes up. Even if I have a local copy of it, I just can't trust it.
    I spent probably 1-2 hours yesterday trying to fix opt-in skin. Uninstalling it didn't really uninstalled it, there was still crappy data somewhere in the database. I just switched to another temporary solution until I get more time to fix it.
    But, well.. you can still set-up an OK website in 2-3 hours, choose from thousands of different themes and plug-ins. And it works. Just don't look at the generated HTML though.
    I know. I disable updates for my clients and do them as late as possible, and I start to sweet when I have to update >10 site to newer wp version. I know that WP is pretty stable, it wont break the site, it could just cause some minor hiccups (mysterious black line somewhere, or images behaving funny) but it can be fixed.
    For me, it's a matter of efficiency/money worth. As I told you, not everybody can buy a Ferrari no matter how long you will explain that I took hours and hours of handcrafting this car.
    By the way, I see hundreds of websites of very famous people and there websites run on Wordpress. Wondering why? These people can afford very expensive website created by big agency and fully handcoded and on Drupal. No. I'd like to speak one day with somebody who creates these kind of sites for these people and hear his/her arguments.

  7. #7
    SitePoint Zealot bronze trophy xMog's Avatar
    Join Date
    Mar 2011
    Posts
    148
    Mentioned
    3 Post(s)
    Tagged
    1 Thread(s)
    Well, I had my blog breaks because there was some kind of conflict between 2 plugins. Nothing was working. I was lucky because I tested it on my local site before

    I guess that if you just need a blog, WordPress is good enough! They probably prefer to pay somebody if it breaks than to build a custom solution from scratch, it's still cheaper I guess. Or they just heard that "WP could do anything" so they asked for it. Who knows.

  8. #8
    SitePoint Wizard silver trophybronze trophy asp_funda's Avatar
    Join Date
    Jun 2003
    Location
    ether
    Posts
    4,497
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by TheRedDevil View Post
    We ran a multisite installation of WordPress for a client a while ago with 200k+ active blogs, and to archive that we had to rewrite all of the plugins they wanted to add + several sections of the core WP code. (+ of course a larger server cluster).
    Core WordPress re-writes? lol I guess the people at wordpress.com have been doing it all wrong all these years, don't know what they smoke!


    Quote Originally Posted by Soapmarine View Post
    I'd like to speak one day with somebody who creates these kind of sites for these people and hear his/her arguments.
    My day job is to work on half a dozen very high traffic websites & they're all powered by WordPress! And I seriously don't want to disrupt the little "I hate WordPress" session going on here!

    Btw, SitePoint itself runs on WordPress, they migrated from a custom CMS to WordPress years ago.
    Our lives teach us who we are.
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Me - Photo Blog - Personal Blog - Dev Blog
    iG:Syntax Hiliter -- Colourize your code in WordPress!!

  9. #9
    SitePoint Wizard TheRedDevil's Avatar
    Join Date
    Sep 2004
    Location
    Norway
    Posts
    1,196
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by asp_funda View Post
    Core WordPress re-writes? lol I guess the people at wordpress.com have been doing it all wrong all these years, don't know what they smoke!
    It might be an idea not to bring up something you dont know anything about.

    Automattic modify the code that wordpress.com runs on, and from time to time they release the tweaks/updates to the community, either by merging it into the wordpress core or as modules.

  10. #10
    SitePoint Wizard silver trophybronze trophy asp_funda's Avatar
    Join Date
    Jun 2003
    Location
    ether
    Posts
    4,497
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    I think I know about how Automattic works especially wp.com as I work with them day in & out. So to quote you - might not be a good idea to tell someone something about which you have no idea!

    Btw, my comment was not derogatory or sarcastic or to poke fun at you. Its just that I mostly see people diss about stuff they don't know jack about (again, not pointing at you) & now I just find it amusing.
    Our lives teach us who we are.
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Me - Photo Blog - Personal Blog - Dev Blog
    iG:Syntax Hiliter -- Colourize your code in WordPress!!

  11. #11
    Community Advisor silver trophybronze trophy
    dresden_phoenix's Avatar
    Join Date
    Jun 2008
    Location
    Madison, WI
    Posts
    2,805
    Mentioned
    34 Post(s)
    Tagged
    2 Thread(s)
    IMHO:
    AM not sure if I would blame this entirely on WP or WP devs. Sometimes his is everyone cutting corners. WP was , at it's core, a 'powerful' personal blogging CMS .. because of it's versatility and PRICE, it became popular; begin offered to clients who wanted to keep project costs down ( and maintain control over future alterations, or even attempt to do them inhouse!)

    Most of what you see is actually CLEVER workarounds of WP core's limitations. If you have expectations of large scale sites being run AS EFFICIENTLY as a custom solution then you have unrealistic expectations of the real world.

  12. #12
    SitePoint Wizard silver trophybronze trophy asp_funda's Avatar
    Join Date
    Jun 2003
    Location
    ether
    Posts
    4,497
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    @dresden_phoenix
    Spot on. Infact, its not just WordPress, comparing any off the shelf CMS with a custom solution is unrealistic as off the shelf CMSes are built in a more generic way which would suit a large number of people so the architecture decisions made for them would be quite different than a custom app. Its more about how easily a CMS allows you to customize it and build upon it your website. In my experience WordPress is more flexible and easier to bend which is one reason for its popularity. Yes that does take a hit on performance and that is something which can be dealt with. Personally sometimes WP does frustrate me but then that is the thing, you have to weigh the pros & cons and see which of them weigh more for you!
    Our lives teach us who we are.
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Me - Photo Blog - Personal Blog - Dev Blog
    iG:Syntax Hiliter -- Colourize your code in WordPress!!


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •