Out of curiosity is there any specific reason for SQL 2008 and not 2014 Express?
No, there is not specific reason, tbh. I might upgrade to SQL 2014, while it's still possible 🙂
I've also noticed that (I think) all DB connections (either to SQL or MySQL) are slow. I'm trying to figure out why. This is not your problem, of course, but just wanted to let you know.
It seems that normal PHP sites and/or asp.net sites are working perfectly. As soon as there is a DB involved... it slows down a lot! TTFB is like 3 or 4 seconds each time...
Will look into it further and post back when I have an answer.
Hmm,
I'm not sure i can't say i can reproduce your issue on our server (with the enterprise set to 127.0.0.1 and app pool tweaks) with a pretty large database and plenty of users every page goes quick other then if it needs to load resources such as website properties, etc.
Do you have any windows auth enabled on any site? (if so disable it on all solidcp sites such as portal, enterprise, server).
So far, I've noticed that the TTFB (Time-To-First-Byte) takes a very, very long time!
When I use a simple PHP page (phpinfo.php for example), it's quick. When I use a simple aspx site, it's quick. As soon as there is ANY database activity involved.... the seconds add up quickly!
Again: I know this doesn't look like a SolidCP panel, but I'm adding it here, so more people might know something OR find something usefull in this thread.
Hey guys,
Just wanted to let you know I've been testing some more and I'm not getting any more performance.
What I did is install a basic blog system in dotNET, using SQL as backend and that site was blazingly fast. I also changed the username/password in the web.config: no performance increase. I also looked up the difference in Application Pool settings and made the SolidCP Application Pool the same as the fast website. It had no difference at all.
I also checked the 3 seperate sites on ports 9002 and 9003. They are very quick as well.
Next: I did a very simple speedtest on the SQL server. That server has the same speed as my local server on a HP server.
In other words: I still have no idea where to find the problem and I'd really like some more ideas and/or help.
Hope to hear from you guys!
