Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Welcome to the CollectiveAccess support forum! Here the developers and community answer questions related to use of the software. Please include the following information in every new issue posted here:

  1. Version of the software that is used, along with browser and version

  2. If the issue pertains to Providence, Pawtucket or both

  3. What steps you’ve taken to try to resolve the issue

  4. Screenshots demonstrating the issue

  5. The relevant sections of your installation profile or configuration including the codes and settings defined for your local elements.


If your question pertains to data import or export, please also include:

  1. Data sample

  2. Your mapping


Answers may be delayed for posts that do not include sufficient information.

Pawtucket slow to load

edited August 2013 in Pawtucket
Novice alert! We've just set up our first CA installation on a remote server as a "virtual museum" for public access. It was a long, slow learning curve but we feel we have something that will work as intended. Our main problem is the time it takes for browsers to load Pawtucket - anything from 15 to 30 seconds. These days nobody is going to stare at a blank screen for that long, they will give up and go away. Can anyone suggest ways of speeding this up (I've checked all the file permissions are correct)? If not, could we have a "loading please wait" window pop up immediately? Any suggestions gratefully received.

The prototype web site is here: http://www.wokingham-tc.gov.uk/museum

Thanks,

Mike

Comments

  • It shouldn't take that long, for sure. What sort of server (operating system and hardware specs) is this running on?
  • It's a shared server running Linux, Apache 2.2.3, PHP 5.3.23 and MySQL 5.5.22.

    I don't know the server hardware spec. I was going to talk to the provider once I'd established that there was a problem.

    Mike
  • Who is the provider?
  • edited August 2013
    http://www.123connect.co.uk/

    I should add that as a government body we can only use approved hosting companies. We get great service from these people but I wanted to establish that the problem isn't caused by our setup first.

    Mike
  • I can't speak to your set up not have direct access to the server, but it should not be so slow. Can you run phpinfo() on the server and send me the output.
  • The host provides a link to phpinfo here:

    http://www.lightning1.co.uk/phpinfo
  • It looks like the server or database is just plain slow. You might want to ask if they have a better level of service. I can't say for sure because I don't have access to the machine, but it might be the classic case of an oversold shared server. If there are too many sites running on the machine, it all gets very slow
  • Thanks Seth. I will speak to them about an upgrade.
  • edited September 2013
    Our host pointed me to this speed test tool and noted the huge amount of scripts and video player being loaded:

    http://tools.pingdom.com/fpt/#!/zZbYl/http://www.wokingham-tc.gov.uk/museum

    Are all these scripts needed, and if not can they be selectively disabled?

    Thanks,

    Mike
  • You can pare them down if you want. But that's not the source of the speed issue. It's taking too long to generate the page in the first place.
  • Hi Mike,

    Do you ever get this resolved? Is there anything we can do to help?
  • Hi Seth

    Thanks for the follow-up. I left it with our host and they have speeded the site up dramatically by implementing a cache for the MySQL database. See what you think:

    http://www.wokingham-tc.gov.uk/museum

    Mike
  • Yeah, it seems snappier. Still not as fast as it should be but not too bad. I wonder what they did to fix it. We've seen a few hosts where mysql is mysteriously slow for no apparently reason. In many of those cases the database is on a separate machine and the network is slow between the web server (where CA) and mysql (where the data is). A cache would help with that.

    In any event, let us know if there's anything else to be done.
Sign In or Register to comment.