IP-CAM

<modification>

    <id>Cache category data to speed up page load for store with many categories and sub categories.</id>
    <version>1.0.1</version>
    <vqmver>2.3.2</vqmver>
    <author>Weismann Web - www.weismannweb.com</author>

    <file name="catalog/controller/extension/module/category.php">
        <operation>
            <search position="after"><![CDATA[

IP-CAM

-- Add these to speed up OpenCart
ALTER TABLE `oc_product` ADD INDEX(`date_available`, `status`);
ALTER TABLE `oc_product` ADD INDEX(`status`);
ALTER TABLE `oc_url_alias` ADD UNIQUE(`query`);
ALTER TABLE `oc_product_to_store` ADD INDEX(`store_id`);
ALTER TABLE `oc_category_path` ADD INDEX(`path_id`, `category_id`);
ALTER TABLE `oc_category_path` ADD INDEX(`category_id`, `path_id`);
ALTER TABLE `oc_product_description` ADD INDEX(`language_id`);
ALTER TABLE `oc_category` ADD INDEX (`parent_id`, `status`, `sort_order`);
ALTER TABLE `oc_category` ADD INDEX(`sort_order`);

IP-CAM

<modification>

    <id>Cache category data to speed up page load for store with many categories and sub categories.</id>
    <version>1.0.1</version>
    <vqmver>2.3.2</vqmver>
    <author>Weismann Web - www.weismannweb.com</author>

    <file name="catalog/controller/module/category.php">
        <operation>
            <search position="after"><![CDATA[