Apache Friends Support Forum

Hello there,

just a suggestion: How would it be to ship XAMPP with better defaults - especially for MySQL.
Problem is that especially for Windows the default preferences work extremly bad. Once i got a 1000 times(!) performance improvement after optimizing my.ini and installing a APC PHP Cache.
(The my.ini defaults are optimized for something like 64MB RAM!)

Greets,
Simon

Hi Fannon,

well, what configuration should be used in your opinion? XAMPP is a testing and development environment, not a stack meant as production server, so performance is not priority 1.
XAMPP ist configured to run on as many hardware as possible. Even on very old pcs with at minimum Windows XP or Linux you can run XAMPP, nearly independend of your RAM, CPU or network performance.

Please feel free to share your configuration changes for exactly your hardware with us so that others can have a benefit from it.

best wishes,
Altrea

Hello Altrea,

yes - of couse you're right about the developement envirionment. BUT I don't think that any developer uses a Computer with 64MB RAM today But otherwise... working and developing on PHP Applications becomes a MUCH better experience when the site loads in 2ms instead of 2253ms. Well, thats my oppinion on it - I dont want to force that upon anyone!

And of couse - you can't do heavy optimizing on a package that should work for everyone.

If you like I can share some Settings I did or what Settings i find generally useful.

Greets,
Fannon

Fannon wrote:BUT I don't think that any developer uses a Computer with 64MB RAM today

Yes, maybe you are right. I for example have a small client who is using an XAMPP on a system with Windows XP and just 256MB Ram for an intranet website for just 3 users. He feels okay with it. It is not fast but for his work he feels okay with it. Where should we draw the line?

Fannon wrote:But otherwise... working and developing on PHP Applications becomes a MUCH better experience when the site loads in 2ms instead of 2253ms.

The performance depends hardly from the used techniques and applications too. if you are using CMS like CakePHP a page can load much longer then procedural php. You don't really feel the difference if a page needs 200ms or 150ms to load
Such comparisons are never fair. Yes, faster is always better! But maybe a configuration which will get your stack very fast has the opposit effect on another user. What i want to say: performance optimazion can't be generalized: It has to be done from user to user.

I don't say that my very own opinion is the only truth. It's just my opinion. i hope you keep that in mind

Fannon wrote:If you like I can share some Settings I did or what Settings i find generally useful.

Well, i personally don't need them because i tweek my systems on my own. But yes, this is a community board from users for users. Maybe your changes will help others who are not sure about all that settings.

best wishes,
Altrea