Solucion Carga lenta de la web.

Code: Select all

#Tabla category campo parent_id
CREATE INDEX i_parent_id ON category (parent_id);

#Tabla category_description campo language_id
CREATE INDEX i_category_description ON category_description (language_id);

#Tabla category_path campos path_id y level
CREATE INDEX i_category_path on category_path (path_id,level);

#Tabla category_to_store campo store_id
CREATE INDEX i_category_to_store on category_to_store (store_id);

#Tabla manufacturer_to_store campo store_id
CREATE INDEX i_manufacturer_to_store on manufacturer_to_store (store_id);

#Tabla product campos manufacturer_id, date_added, date_modified
CREATE INDEX i_product on product (manufacturer_id, date_added, date_modified);

#Tabla product campos model, sku, upc, ean,(como veis donde tengais la referencia etc) y con tipo FULLTEXT (si el campo es de caracteres no de números)
CREATE FULLTEXT INDEX i_product_fulltext on product (model, sku, upc, ean);

#Tabla product_description campo language_id
CREATE INDEX i_product_description on product_description (language_id);

#Tabla product_to_category campo category_id
CREATE INDEX i_product_to_category on product_to_category (category_id);

#Tabla product_to_store campo store_id
CREATE INDEX i_product_to_store on product_to_store (store_id);

#Tabla setting campo store_id, serialized
CREATE INDEX i_setting on setting (store_id, serialized);

#Tabla url_alias campo query con tipo FULLTEXT
CREATE FULLTEXT INDEX i_url_alias on url_alias (query);# 6936 filas afectadas.

#Tabla zone campo country_id
CREATE INDEX i_zone on zone (country_id);

#Tabla zone campo name y code con tipo FULLTEXT
CREATE FULLTEXT INDEX i_zone_fulltext on zone (name,code);

Code: Select all

    #Tabla category campo parent_id
    CREATE INDEX i_parent_id ON category (parent_id);

    #Tabla category_description campo language_id
    CREATE INDEX i_category_description ON category_description (language_id);

    #Tabla category_path campos path_id y level
    CREATE INDEX i_category_path on category_path (path_id,level);

    #Tabla category_to_store campo store_id
    CREATE INDEX i_category_to_store on category_to_store (store_id);

    #Tabla manufacturer_to_store campo store_id
    CREATE INDEX i_manufacturer_to_store on manufacturer_to_store (store_id);

    #Tabla product campos manufacturer_id, date_added, date_modified
    CREATE INDEX i_product on product (manufacturer_id, date_added, date_modified);

    #Tabla product campos model, sku, upc, ean,(como veis donde tengais la referencia etc) y con tipo FULLTEXT (si el campo es de caracteres no de números)
    CREATE FULLTEXT INDEX i_product_fulltext on product (model, sku, upc, ean);

    #Tabla product_description campo language_id
    CREATE INDEX i_product_description on product_description (language_id);

    #Tabla product_to_category campo category_id
    CREATE INDEX i_product_to_category on product_to_category (category_id);

    #Tabla product_to_store campo store_id
    CREATE INDEX i_product_to_store on product_to_store (store_id);

    #Tabla setting campo store_id, serialized
    CREATE INDEX i_setting on setting (store_id, serialized);

    #Tabla url_alias campo query con tipo FULLTEXT
    CREATE FULLTEXT INDEX i_url_alias on url_alias (query);# 6936 filas afectadas.

    #Tabla zone campo country_id
    CREATE INDEX i_zone on zone (country_id);

    #Tabla zone campo name y code con tipo FULLTEXT
    CREATE FULLTEXT INDEX i_zone_fulltext on zone (name,code);