The largest files in in /cache/category/ is 13KB
/cache/extension/ is 15KB
/cache/html_cache/ is 15KB
/cache/resource/ is 12KB
/cache/setting/ is 32KB
Here is the script for generate 380K records (need to run 10 times, because the script will timeout after 3xxxx records in my server)
You can try to generate the dummy records in your testing server
=============================================
<?php
header("Content-Type: text/html; charset=utf-8");
// Database .............
//ini_set('max_execution_time', '3600');
$server = 'localhost:3306';
$database = 'yourdatabasename'; //change this
$datauser = 'databaseusername'; //change this
$password = 'password'; //change this
$connection = mysql_connect($server,$datauser,$password);
if (!$connection) {
die('Could not connect to MySQL database, the server return the error: '.mysql_error());
}
$db = @mysql_select_db($database);
@mysql_query("SET CHARACTER SET UTF8");
if (!mysql_query("SET NAMES 'utf8'", $connection))
return false;
for ($i=1; $i<=50000; $i++) { //need to advance the $i value to new value for each running of this script , i.e for the 2nd time running this script, $i=50001; $i<=100000; I need to run 10times of this script because the script will timeout after generate 3xxxx records00
$d = date("Y-m-d");
$t = date("Y-m-d H:i:s");
$end_date = date("Y-m-d", mktime(0, 0, 0, date("m"), date("d"), date("Y")+20));
$itemcode = "Item " . substr('0000000000' . $i, -8);
$athumb = "catalog/demo/htc_touch_hd_1.jpg";
$brand = 15;
$price = 100;
$points = 100;
$cost = 60;
$weight = 1;
$weburl = "location A";
$topcat = 43;
$maincat = 48;
mysql_query("INSERT INTO abc_products (location, model, quantity, stock_status_id, manufacturer_id, shipping, price, weight, weight_class_id, status, date_available, date_added, date_modified, cost) VALUES ('$weburl', '$itemcode', '100', '3', '$brand', '1', '$price', '$weight', '1', '1', '$d', '$t', '$t', '$cost') ");
$product_id = mysql_insert_id();
$goods_id = $product_id;
$company =0;
mysql_query("INSERT INTO abc_products_to_categories (product_id, category_id) VALUES ('$goods_id', '$maincat') ");
mysql_query("INSERT INTO abc_products_to_categories (product_id, category_id) VALUES ('$goods_id', '$topcat') ");
mysql_query("INSERT INTO abc_products_to_stores (product_id, store_id) VALUES ('$product_id', '$company') ");
$title = "Title " . $itemcode;
$alldesc1 = "商品說明 " . $itemcode; //Chinese name
$alldesc2 = "Product Description " . $itemcode; //English name
$picpath2 = "18/79/1.jpg";
mysql_query("INSERT INTO abc_resource_library (type_id, date_added, date_modified) VALUES ('1', '$t', '$t')");
$resource_id = mysql_insert_id();
mysql_query("INSERT INTO abc_resource_map (resource_id, object_name, object_id, sort_order, date_added, date_modified) VALUE ('$resource_id', 'products', '$product_id', '2', '$t', '$t') ");
mysql_query("INSERT INTO abc_resource_descriptions (resource_id, language_id, name, title, description, resource_path, resource_code, date_added, date_modified) VALUES ('$resource_id', '1', '$alldesc1', '$title', '', '$picpath2', '', '$t', '$t')");
mysql_query("INSERT INTO abc_resource_descriptions (resource_id, language_id, name, title, description, resource_path, resource_code, date_added, date_modified) VALUES ('$resource_id', '2', '$alldesc2', '$title', '', '$picpath2', '', '$t', '$t')");
$keyword = "Keyword-" . substr('0000000000' . $i, -8);
$key1 = "product_id=$product_id";
$keyw1 = $keyword . "-en";
$keyw2 = $keyword . "-hk";
mysql_query("INSERT INTO abc_url_aliases (language_id, query, keyword) VALUES ('1', '$key1', '$keyw1') ");
mysql_query("INSERT INTO abc_url_aliases (language_id, query, keyword) VALUES ('2', '$key1', '$keyw2') ");
mysql_query("INSERT INTO abc_product_descriptions (product_id, language_id, name, meta_keywords, meta_description, description) VALUES ('$product_id', '1', '$title', '$title', '$title', '$alldesc1')" );
mysql_query("INSERT INTO abc_product_descriptions (product_id, language_id, name, meta_keywords, meta_description, description) VALUES ('$product_id', '2', '$title', '$title', '$title', '$alldesc2')" );
$mprice = 99;
$vprice = 98;
$vvprice = 97;
mysql_query("INSERT INTO abc_product_discounts (product_id, customer_group_id, quantity, price) VALUES ('$product_id', '8', '1', '$mprice') "); //reg. member price;
mysql_query("INSERT INTO abc_product_discounts (product_id, customer_group_id, quantity, price) VALUES ('$product_id', '9', '1', '$vprice') "); //vip. member price;
mysql_query("INSERT INTO abc_product_discounts (product_id, customer_group_id, quantity, price) VALUES ('$product_id', '10', '1', '$vvprice') "); //wholesale. member price;
mysql_query("INSERT INTO abc_product_options (product_id, status, element_type, required) VALUES ('$product_id', '1', 'S', '1') ");
$product_option_id = mysql_insert_id();
$oname = "color";
mysql_query("INSERT INTO abc_product_option_descriptions (product_option_id, language_id, product_id, name) VALUES ('$product_option_id', '1', '$product_id', '$oname')");
mysql_query("INSERT INTO abc_product_option_descriptions (product_option_id, language_id, product_id, name) VALUES ('$product_option_id', '2', '$product_id', '$oname')");
$optprice =0;
$weight = 0;
for ($h = 1; $h <= 10; $h++) {
mysql_query("INSERT INTO abc_product_option_values (product_option_id, product_id, quantity, subtract, price, prefix, weight, weight_type, attribute_value_id, sort_order)
VALUES ('$product_option_id', '$product_id', '50', '0', '$optprice', '$', '$weight', 'kg', '0', '0')");
$product_option_value_id = mysql_insert_id();
$color = 50;
$optprice = 0;
$optvalue = "Color " . $h;
mysql_query("INSERT INTO abc_product_option_value_descriptions (product_option_value_id, language_id, product_id, name, grouped_attribute_names) VALUES ('$product_option_value_id', '1', '$product_id', '$optvalue', '')" );
mysql_query("INSERT INTO abc_product_option_value_descriptions (product_option_value_id, language_id, product_id, name, grouped_attribute_names) VALUES ('$product_option_value_id', '2', '$product_id', '$optvalue', '')" );
}
}
echo "end of program...";
die();
?>