Mark Optimise The MySql Database Design Structure Please?

@Mark I beg of you….

I should qualify that much of the initial issue was my content management cock ups.
which on the journey to resolve I discovered a lot….
=======================================================================
You produce terrific WP Themes – however…….

The scripts simply cant cope with any kind of major volume of listings because that database design structures are not optimised with inbuilt MySql indexes/caching/.

So they are only suitable at the moment for tiny databases and have limited scalability options.

You should be able to scale up any WordPress Theme to enterprise level with intelligent structures – and looking at other WP Developers – the financial opportunity is there now to charge for Enterprise “like” Themes.

To scale up beyond a few 100 listings gets everyone hot and bothered like that kind of success is a disease and I get depressed by how many start a response with the lazy phrase:

“well you see the problem is you have too many listings…..” or “….who wants to order food from their sofa….” ” it’s a 3rd party plugin….”

Oh and attracting that level is a mark of failure is it? Plugins are these alien things that WP has picked up along the way!

The lack of ambition is startling and wretched all at once and setting yourself up for limitations.

We are then forced to adopt plugins which help correctly and compensate and these bring their own problems – which PP conveniently then say it not your problem….which is depressing really – because it is a jobs board which should handle 100,000s of listings – without a problem especially on a powerful server like mine.

Optimising databases should be integral to the original design of the MySql design of each theme – it is the essence of WordPress. That way we should not need the use of 3rd party plugins or scripts which then clash with the themes.

So far greater attention paid to making this work better and for decent scalability. Its very disappointing this – which is a shame because the themes are excellent otherwise but spoiled by this fundamental self defeating and entirely un -inspired limitation.

I will demonstrate this as I add back content. Now that I have removed almost all the listings

It is extremely fast.

I will add content over the next few days and watch how it then slows down markedly.

Largely because it queries the database in a long winded fashion and not using indexes or other basic optimisation protocols.

thanks

mike