Mailinglist Archive: opensuse (908 mails)

< Previous Next >
Re: [opensuse] apache 2.4 performance issue / processwire.
Op woensdag 8 juni 2016 18:23:33 CEST schreef Per Jessen:
The developer claims the site serves fine on his own PC (typical
multi-core thingie)

And he has developped for a single user website on an equivalent of his PC ?
If he's a real webdevelopper he should know that his claim is useless.

This is about how I work:
- development environment locally. Using just a small amount of the data
- test environment, using the full data collection, stress testing should be
included ( what if X users hit the URL and trigger query Y to run ), needs to
be on (preferably) an identical machine.
- production environment, where only stuff lands that has proven to result in
a proper working situation.

Things I've seen where developers / designers claimed "it was running OK on
their machine" :
- MySQL databases with no indices ( works fine locally with 2 customers, 10
products, 10 orders )
- Huge queries that should only run for logged in users, but placed outside
the closed parts of the site
- Badly writen queries ( with OK results .... easily done )
- Calls to external webservices being left out

In my experience apache and nginx are hardly ever the cause of websites
running slow. Too many high res pictures can be one, but most modern CMS's
have their own caches, where they keep resized images, some even reduce on the
fly when uploading pics. Most of the issues in the performance area I've seen
are related to queries. The amount of attempts to "load everything we need in
one query" .... sigh.

Gertjan Lettink, a.k.a. Knurpht

openSUSE Board Member
openSUSE Forums Team
To unsubscribe, e-mail: opensuse+unsubscribe@xxxxxxxxxxxx
To contact the owner, e-mail: opensuse+owner@xxxxxxxxxxxx

< Previous Next >