woolfcom

The WordPress community should make far more effort to demystify this fundamental – so that it does not cost so much

All this lack of accessibility does is restrict its growth un-necessarily

lovely.

Pretty much realized your conclusion ….

You would think some Whizz have thought to simplify such a fundamental.

I am talking with DBAs….and everyone else – was hoping to find a more direct resolution/solution….than studying the matter academically

Now I see why there are so few solutions and why Oracle keeps it so close to their chests – its a bit short-termist

tx

I know 20,000 is tiny when you have a requirement to scale up to 2,000,000 [and the hardware to handle that]

Before expanding the hardware – we need to get a well optimized set up. We are making progress but…..

– Our Theme is stylish but not optimized for performance – so we are working on that too. The biggest logjam is the MySql performance on queries [which you get].

– No indexes – i have no idea how to code this

– using quick cache

– read a mass of optimization and tuning [MySql and PHP] – server settings – SpeedChecks – compression – caching – and see a wide range of suggestion most of which remarkably contradictory

– faster searching is the primary goal for usability – the manual membership is plenty fast enough

– the majority of our content is imported and the speed of this not materially vital since it can be run in the background

– read quite a bit on Indexes but steep learning curve [yes I am looking to do it myself – for cost and knowledge]

Is there a plugin solution which adds in Indexes?

I like the sound of spreading the load by running multiple databases – but it sounds devilishly complex.

There ought to be a section of WordPress dedicated to just MySql.

Or databases in general –

A Legion of stuff on Themes and general coding – but a paucity on a fundamental structure of this great CMS!

and an issue which massively affects the performance of the CMS.

As soon as we imported more than 20,000 posts [jobs listings in this case] – the MySql database queries ground to a halt in terms of speed.

Thus rendering the search all but unusable.

We have tried several Cache plugins – arriving at patchy outcomes.

We have looked extensively for “Mysql Layer” – and cant find solutions which does involve major over-complex re-writes and therefore un-economic.

There is very little help on MySql on WordPress – much less help on Tuning and Optimising MySql

Which should be built in to WordPress as a matter of course – its the core functionaliy.

The performance of which is fundamental to the WordPress raison d’etre concept of content handling.

Can I recommend that these Enterprises are likely to possess huge resources.

I am talking about the Little but ambitious operators who rely the ability to compete on an entrepreneurial level, by being nimble.

This is what WP is all about!

20,000 posts causing a massive halt in useability is really poor performance.

Scalability on such a minor level should be already built in to WordPress without complex layering.

This is such a small amount of content.

Tried that

It does not allow me to Post there for some reason!

Have also looked and not found much on MySql Tuning on WordPress.

I would have thought this was a fundamental

Which is disappointing – hence why I tried misc.

jobs listings

manage and listing them

probably not

Yes should I post these elsewhere?

Any clues on this issue please?

I have issued a support ticket FYI.

FYI

I would interested in buying the premium version if you could provide an answer for the issue of GET requests.

Reminder: we use friendly URLs for our normal structure.

We have extensive search results obtained by GET requests.

The static pages on my site works fine.

The page simply goes blank when I try to search or navigate search results – so the screenshot will show a blank page!

There is no error message.

I believe I have responded to this elsewhere.

I got my original downloaded version thanks.

Checking the principal server usage was the file import process when wp all import was running and the consequent MySql processes spike arising.

All other processes were well within limits and generally insignificant.

The earlier version does on the face of it seem to run smoother without so many server warnings.

That said I also removed the image uploads [extremely useful] and stuck with my Theme default image.

So I am not clear which helped the speed and reduced server load.

FYI I also find that the plugin stops my search form from working – so I de-activate it when not in use.

Perhaps you can have a “sleep” mode?
Perhaps you can have a “flush cache” [wp import processes only] or “cease processes” facility to reduce server loads – once the import has completed?

All that said – I generally love using the premium plugin which is extremely simple and effective to use and very much appreciate your attention to support and detail [which all plugin developers might learn about developing Premium products when its worth paying].

If you could suggest optimum server settings guidelines that would also help enormously.

OK let’s see:

ALL of our searches includes query strings??
We ARE using friendly permalinks as well

QC – says only use one or the other and preferably NOT caching GET requests – so that is confusing and seems inflexible. Programming the exceptions is a lot of work.

Your explanation is contrary to the recommended on the plugin README itself.

We presently have 150,000 listings.

How can I cache so many pages so our Viewers can use the site?

The search results currently simply return a blank page – but now I understand about that arising from the lack of caching GETs.

Does the Pro Version cover these issues and is it an multi site license?

Ah Thanks

Interestingly I tested your plugin with:

WP All Import Pro

…activated.

My search form stopped working. When the same was de-activated the search form started working again.

There is obviously a common issue there. I will let them know as well.

No it was exactly the same Theme.

The plugin worked just fine until recently. Then it had the effect of stopping the Theme’s search form from working….which is the essential problem.

I have asked PP designers and they say it’s the Plugin.

I also noticed that several other plugins stopped the same search form from working…so am guessing that they [plugins/theme] are using conflicting files…

so trying to get to the bottom of the issue….