Jump to content

Welcome, Guest!

By registering with us, you'll be able to discuss, share and private message with other members of our community.

musicmaster

[solved] A very slow site

Recommended Posts

I am working on a new shop but it is very slow. My homepage takes 32 seconds. When I switch profiling on there is one query that is responsible for 28 of the 32 (see image). Does anyone have an idea what is happening here?

This is TB 1.08 on PHP 7.2.

delay.jpg

Edited by musicmaster

Share this post


Link to post
Share on other sites
18 minutes ago, musicmaster said:

Solved. Some indexes were missing.

Can you explain more? I would have thought the installaion would automatically set all the correct indexes.

Our site is a little slow, so how would i check those indexes and correct them?

Share this post


Link to post
Share on other sites

This installation was copied from a local computer to the server. But the file was to big so only half the tables were filled. So I made a new sql file for the second half of the tables. That worked ok. But I had forgotten that the indexes are always at the bottom of a sql file. So those for the first half had never been executed.

The only way to check whether a table is indexed is to have a look in phpmyadmin. When your main tables such as ps_product are ok it is unlikely there is a problem. If you find something missing you can copy the settings from a fresh install of the same TB version.

  • Like 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...