Cache files not being created

[rerbe]

Hi All

 

I have been checking the speed of my site and I have discovered that the cache file are not being created, I have checked and double checked the path in the cache setup.

 

Can anyone help.

 

Cheers

 

Richard :angry:

[Guest]

Lots of things to check...first, make a new directory above the document root and chmod 777. Then, change the path value to the absolute FS path to the directory.

 

Then, surf the site for a bit and make sure the files are created.

[rerbe]

Tried this but still no luck, sitll no files.

 

The Parse Time id 0.437 s with 541 queries, I was condindering installing your Page Cache - Faster Pages contrib, in your opinion would this 'solve' my problem.

 

Cheers

 

Richard

[boxtel]

Tried this but still no luck, sitll no files.

 

The Parse Time id 0.437 s with 541 queries, I was condindering installing your Page Cache - Faster Pages contrib, in your opinion would this 'solve' my problem.

 

Cheers

 

Richard

<{POST_SNAPBACK}>

 

with 541 queries you may have to do some more than caching

[rerbe]

Any Ideas??

[boxtel]

Any Ideas??

<{POST_SNAPBACK}>

 

I put my cache files on a ramdisk z:\cache

 

so in the cache path under admin I have

 

z:/cache/

[rerbe]

I am running on a shared server so I do not have access to be able to do this.

 

I have tried to optimise the database but still no luck.

 

Do you know what actually causes the requests (what looks at the database) on the product page so I can look into why this is so high.

 

I have very minimal PHP/Mysql programming skills though.

 

Cheers

[boxtel]

I am running on a shared server so I do not have access to be able to do this.

 

I have tried to optimise the database but still no luck.

 

Do you know what actually causes the requests (what looks at the database) on the product page so I can look into why this is so high.

 

I have very minimal PHP/Mysql programming skills though.

 

Cheers

<{POST_SNAPBACK}>

 

implement the debug mod from chemo,

it will show you exactly which queries are being performed.

[rerbe]

I did this and this was the response

 

QUERY DEBUG:

Array

(

[QUERIES] => Array

(

[0] => select configuration_key as cfgKey, configuration_value as cfgValue from configuration

[1] => select value from sessions where sesskey = '793020dc0df26cde34581a6a33bb02ac' and expiry > '1102431191'

[2] => select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies

[3] => select languages_id, name, code, image, directory from languages order by sort_order

[4] => delete from whos_online where time_last_click < '1102430291'

[5] => select count(*) as count from whos_online where session_id = '793020dc0df26cde34581a6a33bb02ac'

[6] => insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '793020dc0df26cde34581a6a33bb02ac', '172.185.72.46', '1102431191', '1102431191', '//index.php?output=1')

[7] => select banners_id, date_scheduled from banners where date_scheduled != ''

[8] => select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id

[9] => select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0

[10] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name

[11] => select count(*) as count from categories where parent_id = '216'

[12] => select count(*) as count from categories where parent_id = '21'

[13] => select count(*) as count from categories where parent_id = '26'

[14] => select count(*) as count from categories where parent_id = '30'

[15] => select count(*) as count from categories where parent_id = '33'

[16] => select count(*) as count from categories where parent_id = '34'

[17] => select count(*) as count from categories where parent_id = '35'

[18] => select count(*) as count from categories where parent_id = '38'

[19] => select count(*) as count from categories where parent_id = '39'

[20] => select count(*) as count from categories where parent_id = '41'

[21] => select count(*) as count from categories where parent_id = '46'

[22] => select count(*) as count from categories where parent_id = '98'

[23] => select count(*) as count from categories where parent_id = '51'

[24] => select count(*) as count from categories where parent_id = '52'

[25] => select count(*) as count from categories where parent_id = '53'

[26] => select count(*) as count from categories where parent_id = '54'

[27] => select count(*) as count from categories where parent_id = '55'

[28] => select count(*) as count from categories where parent_id = '56'

[29] => select count(*) as count from categories where parent_id = '60'

[30] => select count(*) as count from categories where parent_id = '66'

[31] => select count(*) as count from categories where parent_id = '69'

[32] => select count(*) as count from categories where parent_id = '79'

[33] => select count(*) as count from categories where parent_id = '129'

[34] => select count(*) as count from categories where parent_id = '88'

[35] => select count(*) as count from categories where parent_id = '93'

[36] => select count(*) as count from categories where parent_id = '96'

[37] => select count(*) as count from categories where parent_id = '97'

[38] => select count(*) as count from categories where parent_id = '65'

[39] => select count(*) as count from categories where parent_id = '130'

[40] => select count(*) as count from categories where parent_id = '131'

[41] => select count(*) as count from categories where parent_id = '146'

[42] => select count(*) as count from categories where parent_id = '151'

[43] => select count(*) as count from categories where parent_id = '155'

[44] => select count(*) as count from categories where parent_id = '163'

[45] => select count(*) as count from categories where parent_id = '169'

[46] => select count(*) as count from categories where parent_id = '174'

[47] => select count(*) as count from categories where parent_id = '181'

[48] => select count(*) as count from categories where parent_id = '185'

[49] => select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name

[50] => select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' order by products_date_added desc limit 10

[51] => select products_name from products_description where products_id = '821' and language_id = '1'

[52] => select specials_new_products_price from specials where products_id = '821' and status

[53] => select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '217') and tr.tax_class_id = '1' group by tr.tax_priority

[54] => select distinct p.products_id, pd.products_name, products_image from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10

[55] => select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added desc limit 10

[56] => select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '217') and tr.tax_class_id = '1' group by tr.tax_priority

[57] => select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '217') and tr.tax_class_id = '1' group by tr.tax_priority

[58] => select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id where products_status = '1' and TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) < 15 order by p.products_date_added desc limit 10

[59] => select products_name from products_description where products_id = '818' and language_id = '1'

[60] => select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '217') and tr.tax_class_id = '1' group by tr.tax_priority

[61] => select products_name from products_description where products_id = '814' and language_id = '1'

[62] => select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '217') and tr.tax_class_id = '1' group by tr.tax_priority

[63] => select products_name from products_description where products_id = '817' and language_id = '1'

[64] => select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '217') and tr.tax_class_id = '1' group by tr.tax_priority

[65] => select products_name from products_description where products_id = '820' and language_id = '1'

[66] => select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '217') and tr.tax_class_id = '1' group by tr.tax_priority

[67] => select products_name from products_description where products_id = '821' and language_id = '1'

[68] => select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '217') and tr.tax_class_id = '1' group by tr.tax_priority

[69] => select products_name from products_description where products_id = '816' and language_id = '1'

[70] => select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '217') and tr.tax_class_id = '1' group by tr.tax_priority

[71] => select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '1' order by products_name desc limit 0

[72] => select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10

[73] => select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '1' and languages_id = '1'

[74] => select startdate, counter from counter

[75] => update counter set counter = '8303'

[76] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name

[77] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '216' order by c.sort_order, cd.categories_name

[78] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '21' order by c.sort_order, cd.categories_name

[79] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '22' order by c.sort_order, cd.categories_name

[80] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '104' order by c.sort_order, cd.categories_name

[81] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '24' order by c.sort_order, cd.categories_name

[82] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '25' order by c.sort_order, cd.categories_name

[83] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '105' order by c.sort_order, cd.categories_name

[84] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '26' order by c.sort_order, cd.categories_name

[85] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '27' order by c.sort_order, cd.categories_name

[86] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '106' order by c.sort_order, cd.categories_name

[87] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '31' order by c.sort_order, cd.categories_name

[88] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '50' order by c.sort_order, cd.categories_name

[89] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '28' order by c.sort_order, cd.categories_name

[90] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '32' order by c.sort_order, cd.categories_name

[91] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '29' order by c.sort_order, cd.categories_name

[92] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '30' order by c.sort_order, cd.categories_name

[93] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '33' order by c.sort_order, cd.categories_name

[94] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '34' order by c.sort_order, cd.categories_name

[95] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '108' order by c.sort_order, cd.categories_name

[96] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '107' order by c.sort_order, cd.categories_name

[97] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '35' order by c.sort_order, cd.categories_name

[98] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '207' order by c.sort_order, cd.categories_name

[99] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '203' order by c.sort_order, cd.categories_name

[100] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '204' order by c.sort_order, cd.categories_name

[101] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '205' order by c.sort_order, cd.categories_name

[102] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '36' order by c.sort_order, cd.categories_name

[103] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '40' order by c.sort_order, cd.categories_name

[104] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '38' order by c.sort_order, cd.categories_name

[105] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '39' order by c.sort_order, cd.categories_name

[106] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '41' order by c.sort_order, cd.categories_name

[107] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '214' order by c.sort_order, cd.categories_name

[108] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '43' order by c.sort_order, cd.categories_name

[109] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '42' order by c.sort_order, cd.categories_name

[110] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '44' order by c.sort_order, cd.categories_name

[111] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '110' order by c.sort_order, cd.categories_name

[112] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '46' order by c.sort_order, cd.categories_name

[113] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '47' order by c.sort_order, cd.categories_name

[114] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '48' order by c.sort_order, cd.categories_name

[115] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '111' order by c.sort_order, cd.categories_name

[116] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '45' order by c.sort_order, cd.categories_name

[117] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '189' order by c.sort_order, cd.categories_name

[118] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '98' order by c.sort_order, cd.categories_name

[119] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '201' order by c.sort_order, cd.categories_name

[120] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '202' order by c.sort_order, cd.categories_name

[121] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '51' order by c.sort_order, cd.categories_name

[122] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '52' order by c.sort_order, cd.categories_name

[123] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '53' order by c.sort_order, cd.categories_name

[124] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '54' order by c.sort_order, cd.categories_name

[125] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '112' order by c.sort_order, cd.categories_name

[126] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '113' order by c.sort_order, cd.categories_name

[127] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '55' order by c.sort_order, cd.categories_name

[128] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '114' order by c.sort_order, cd.categories_name

[129] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '117' order by c.sort_order, cd.categories_name

[130] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '118' order by c.sort_order, cd.categories_name

[131] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '119' order by c.sort_order, cd.categories_name

[132] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '120' order by c.sort_order, cd.categories_name

[133] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '115' order by c.sort_order, cd.categories_name

[134] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '121' order by c.sort_order, cd.categories_name

[135] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '56' order by c.sort_order, cd.categories_name

[136] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '122' order by c.sort_order, cd.categories_name

[137] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '198' order by c.sort_order, cd.categories_name

[138] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '199' order by c.sort_order, cd.categories_name

[139] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '196' order by c.sort_order, cd.categories_name

[140] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '197' order by c.sort_order, cd.categories_name

[141] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '200' order by c.sort_order, cd.categories_name

[142] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '58' order by c.sort_order, cd.categories_name

[143] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '59' order by c.sort_order, cd.categories_name

[144] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '60' order by c.sort_order, cd.categories_name

[145] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '61' order by c.sort_order, cd.categories_name

[146] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '62' order by c.sort_order, cd.categories_name

[147] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '63' order by c.sort_order, cd.categories_name

[148] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '64' order by c.sort_order, cd.categories_name

[149] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '66' order by c.sort_order, cd.categories_name

[150] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '67' order by c.sort_order, cd.categories_name

[151] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '68' order by c.sort_order, cd.categories_name

[152] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '69' order by c.sort_order, cd.categories_name

[153] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '70' order by c.sort_order, cd.categories_name

[154] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '71' order by c.sort_order, cd.categories_name

[155] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '123' order by c.sort_order, cd.categories_name

[156] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '73' order by c.sort_order, cd.categories_name

[157] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '74' order by c.sort_order, cd.categories_name

[158] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '72' order by c.sort_order, cd.categories_name

[159] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '75' order by c.sort_order, cd.categories_name

[160] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '208' order by c.sort_order, cd.categories_name

[161] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '78' order by c.sort_order, cd.categories_name

[162] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '124' order by c.sort_order, cd.categories_name

[163] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '195' order by c.sort_order, cd.categories_name

[164] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '79' order by c.sort_order, cd.categories_name

[165] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '80' order by c.sort_order, cd.categories_name

[166] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '83' order by c.sort_order, cd.categories_name

[167] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '84' order by c.sort_order, cd.categories_name

[168] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '85' order by c.sort_order, cd.categories_name

[169] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '129' order by c.sort_order, cd.categories_name

[170] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '210' order by c.sort_order, cd.categories_name

[171] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '211' order by c.sort_order, cd.categories_name

[172] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '88' order by c.sort_order, cd.categories_name

[173] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '90' order by c.sort_order, cd.categories_name

[174] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '191' order by c.sort_order, cd.categories_name

[175] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '89' order by c.sort_order, cd.categories_name

[176] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '91' order by c.sort_order, cd.categories_name

[177] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '192' order by c.sort_order, cd.categories_name

[178] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '93' order by c.sort_order, cd.categories_name

[179] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '94' order by c.sort_order, cd.categories_name

[180] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '95' order by c.sort_order, cd.categories_name

[181] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '96' order by c.sort_order, cd.categories_name

[182] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '97' order by c.sort_order, cd.categories_name

[183] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '65' order by c.sort_order, cd.categories_name

[184] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '126' order by c.sort_order, cd.categories_name

[185] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '76' order by c.sort_order, cd.categories_name

[186] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '77' order by c.sort_order, cd.categories_name

[187] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '130' order by c.sort_order, cd.categories_name

[188] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '131' order by c.sort_order, cd.categories_name

[189] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '132' order by c.sort_order, cd.categories_name

[190] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '133' order by c.sort_order, cd.categories_name

[191] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '146' order by c.sort_order, cd.categories_name

[192] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '151' order by c.sort_order, cd.categories_name

[193] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '152' order by c.sort_order, cd.categories_name

[194] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '153' order by c.sort_order, cd.categories_name

[195] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '154' order by c.sort_order, cd.categories_name

[196] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '155' order by c.sort_order, cd.categories_name

[197] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '157' order by c.sort_order, cd.categories_name

[198] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '156' order by c.sort_order, cd.categories_name

[199] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '158' order by c.sort_order, cd.categories_name

[200] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '212' order by c.sort_order, cd.categories_name

[201] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '160' order by c.sort_order, cd.categories_name

[202] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '186' order by c.sort_order, cd.categories_name

[203] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '161' order by c.sort_order, cd.categories_name

[204] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '162' order by c.sort_order, cd.categories_name

[205] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '190' order by c.sort_order, cd.categories_name

[206] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '193' order by c.sort_order, cd.categories_name

[207] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '163' order by c.sort_order, cd.categories_name

[208] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '164' order by c.sort_order, cd.categories_name

[209] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '165' order by c.sort_order, cd.categories_name

[210] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '168' order by c.sort_order, cd.categories_name

[211] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '166' order by c.sort_order, cd.categories_name

[212] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '167' order by c.sort_order, cd.categories_name

[213] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '169' order by c.sort_order, cd.categories_name

[214] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '170' order by c.sort_order, cd.categories_name

[215] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '171' order by c.sort_order, cd.categories_name

[216] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '215' order by c.sort_order, cd.categories_name

[217] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '172' order by c.sort_order, cd.categories_name

[218] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '174' order by c.sort_order, cd.categories_name

[219] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '176' order by c.sort_order, cd.categories_name

[220] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '175' order by c.sort_order, cd.categories_name

[221] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '177' order by c.sort_order, cd.categories_name

[222] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '178' order by c.sort_order, cd.categories_name

[223] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '179' order by c.sort_order, cd.categories_name

[224] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '180' order by c.sort_order, cd.categories_name

[225] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '181' order by c.sort_order, cd.categories_name

[226] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '183' order by c.sort_order, cd.categories_name

[227] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '209' order by c.sort_order, cd.categories_name

[228] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '185' order by c.sort_order, cd.categories_name

[229] => SELECT categories_id, categories_name FROM categories_description

[230] => select count(*) as total from sessions where sesskey = '793020dc0df26cde34581a6a33bb02ac'

[231] => insert into sessions values ('793020dc0df26cde34581a6a33bb02ac', '1102432631', 'SESSION_USER_AGENT|s:62:\"Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Tesco; SV1)\";cart|O:12:\"shoppingcart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"GBP\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:6:\"output\";s:1:\"1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}')

)

 

[TIME] => Array

(

[0] => 0.003385

[1] => 0.000649

[2] => 0.000685

[3] => 0.000676

[4] => 0.000605

[5] => 0.000326

[6] => 0.000233

[7] => 0.000603

[8] => 0.000525

[9] => 0.000652

[10] => 0.002507

[11] => 0.000461

[12] => 0.000258

[13] => 0.000242

[14] => 0.000214

[15] => 0.000218

[16] => 0.000219

[17] => 0.000228

[18] => 0.000230

[19] => 0.000220

[20] => 0.000239

[21] => 0.000229

[22] => 0.000229

[23] => 0.000225

[24] => 0.000228

[25] => 0.000236

[26] => 0.000331

[27] => 0.000240

[28] => 0.000372

[29] => 0.000249

[30] => 0.000242

[31] => 0.000235

[32] => 0.000240

[33] => 0.000235

[34] => 0.000235

[35] => 0.000229

[36] => 0.000227

[37] => 0.000215

[38] => 0.000235

[39] => 0.000323

[40] => 0.000319

[41] => 0.000245

[42] => 0.000237

[43] => 0.000245

[44] => 0.000246

[45] => 0.000246

[46] => 0.000235

[47] => 0.000243

[48] => 0.000218

[49] => 0.001447

[50] => 0.000961

[51] => 0.000601

[52] => 0.000355

[53] => 0.001049

[54] => 0.035682

[55] => 0.000658

[56] => 0.000446

[57] => 0.001617

[58] => 0.002860

[59] => 0.000357

[60] => 0.000431

[61] => 0.000275

[62] => 0.000409

[63] => 0.000290

[64] => 0.000399

[65] => 0.000268

[66] => 0.000399

[67] => 0.000324

[68] => 0.000415

[69] => 0.000278

[70] => 0.000408

[71] => 0.000360

[72] => 0.011236

[73] => 0.000387

[74] => 0.000539

[75] => 0.000258

[76] => 0.002127

[77] => 0.000455

[78] => 0.000524

[79] => 0.000395

[80] => 0.000334

[81] => 0.000324

[82] => 0.000326

[83] => 0.000332

[84] => 0.000580

[85] => 0.000395

[86] => 0.000344

[87] => 0.000321

[88] => 0.000321

[89] => 0.000321

[90] => 0.000329

[91] => 0.000333

[92] => 0.000340

[93] => 0.003124

[94] => 0.000598

[95] => 0.000418

[96] => 0.000339

[97] => 0.000544

[98] => 0.000406

[99] => 0.000323

[100] => 0.000320

[101] => 0.000318

[102] => 0.000327

[103] => 0.000321

[104] => 0.000337

[105] => 0.000337

[106] => 0.000501

[107] => 0.000390

[108] => 0.000335

[109] => 0.000325

[110] => 0.000325

[111] => 0.000335

[112] => 0.000512

[113] => 0.000389

[114] => 0.000330

[115] => 0.000331

[116] => 0.000325

[117] => 0.000324

[118] => 0.000444

[119] => 0.000372

[120] => 0.000320

[121] => 0.000329

[122] => 0.000347

[123] => 0.000323

[124] => 0.000434

[125] => 0.000389

[126] => 0.000331

[127] => 0.000567

[128] => 0.000408

[129] => 0.000362

[130] => 0.000342

[131] => 0.000327

[132] => 0.000333

[133] => 0.000525

[134] => 0.000422

[135] => 0.000628

[136] => 0.000409

[137] => 0.000350

[138] => 0.000376

[139] => 0.000350

[140] => 0.000337

[141] => 0.000337

[142] => 0.000331

[143] => 0.000332

[144] => 0.000506

[145] => 0.000402

[146] => 0.000322

[147] => 0.000325

[148] => 0.000318

[149] => 0.000471

[150] => 0.000403

[151] => 0.000343

[152] => 0.000677

[153] => 0.000417

[154] => 0.000356

[155] => 0.005540

[156] => 0.000432

[157] => 0.000359

[158] => 0.000329

[159] => 0.000326

[160] => 0.000327

[161] => 0.000331

[162] => 0.000339

[163] => 0.000317

[164] => 0.005018

[165] => 0.000432

[166] => 0.001023

[167] => 0.000425

[168] => 0.000691

[169] => 0.000747

[170] => 0.000640

[171] => 0.000359

[172] => 0.000757

[173] => 0.000430

[174] => 0.000337

[175] => 0.000330

[176] => 0.000330

[177] => 0.000318

[178] => 0.000440

[179] => 0.000401

[180] => 0.000339

[181] => 0.000364

[182] => 0.000324

[183] => 0.000687

[184] => 0.000433

[185] => 0.000338

[186] => 0.000344

[187] => 0.000347

[188] => 0.000450

[189] => 0.000410

[190] => 0.000347

[191] => 0.000358

[192] => 0.000473

[193] => 0.000417

[194] => 0.000327

[195] => 0.000330

[196] => 0.000649

[197] => 0.000426

[198] => 0.000340

[199] => 0.000333

[200] => 0.000330

[201] => 0.000337

[202] => 0.000326

[203] => 0.000329

[204] => 0.000328

[205] => 0.000314

[206] => 0.000315

[207] => 0.000540

[208] => 0.000422

[209] => 0.000347

[210] => 0.000336

[211] => 0.000339

[212] => 0.000325

[213] => 0.000516

[214] => 0.000416

[215] => 0.000335

[216] => 0.000338

[217] => 0.000324

[218] => 0.000570

[219] => 0.000416

[Guest]

I did this and this was the response

 

<SNIP whole bunch of junk>

<{POST_SNAPBACK}>

It is clear your cache is not configured correctly. I would suggest looking at your phpinfo page and get the document root. Then, use the absolute file system path for the cache directory setting.

 

BTW, please refrain from posting all the ouput in future posts. It clutters the thread and a summary would suffice.

[rerbe]

Sorry about that..

 

I have been trying many ways and many days to get the cache files working, creating directires in different parts of the site chmodding to 777, changing the cache path in the admin all with no luck.

 

After some intensive reading of the boards I have discovered that the cache will not work unless you utilise the Force Cookie Usage in the admin, is this true?

 

If so the problem is that I am using a shared server (and SSL) and as far as I can see I can not use cokkies on this type of setup.

 

Can you give any advice if this is the case?

 

Thanks :'(

[boxtel]

Sorry about that..

 

I have been trying many ways and many days to get the cache files working, creating directires in different parts of the site chmodding to 777, changing the cache path in the admin all with no luck.

 

After some intensive reading of the boards I have discovered that the cache will not work unless you utilise the Force Cookie Usage in the admin, is this true?

 

If so the problem is that I am using a shared server (and SSL) and as far as I can see I can not use cokkies on this type of setup.

 

Can you give any advice if this is the case?

 

Thanks  :'(

<{POST_SNAPBACK}>

 

I never force cookies and page cache is fine.

[boxtel]

I never force cookies and page cache is fine.

<{POST_SNAPBACK}>

 

and turn off your category count will help a lot.

[rerbe]

Cheers

 

Would I still need to set up the cookie path in configuration.php??

 

<_<

[rerbe]

Sorry configure.php

:sweating:

[boxtel]

Sorry configure.php

:sweating:

<{POST_SNAPBACK}>

 

ofcourse, force cookie means that you will not accept processing without one.

if you set force cookie to false, a cookie is still set if accepted, if not, the system goes on with sessions and no cookie.

[boxtel]

ofcourse, force cookie means that you will not accept processing without one.

if you set force cookie to false, a cookie is still set if accepted, if not, the system goes on with sessions and no cookie.

<{POST_SNAPBACK}>

 

 

from you queries I see that you have a huge amount of categories. I would only get the top level ones and only retrieve the sub categories when necessary. Unless you use a DHTML menu ofcourse.

[rerbe]

Another development,

I have been messing around with the cookies settings in configure.php

(domains etc) and now it seems that the cache is working but when I look at the dir using ftp I have loads of files is this correct.

 

Example of cache directory.

 

/tmp/also_purchased-english.cache

/tmp/categories_box-english.cache129

/tmp/categories_box-english.cache21

/tmp/categories_box-english.cache216

/tmp/categories_box-english.cache38

/tmp/categories_box-english.cache39

/tmp/categories_box-english.cache41

/tmp/categories_box-english.cache60

/tmp/categories_box-english.cache60_61

/tmp/categories_box-english.cache60_62

/tmp/categories_box-english.cache60_63

/tmp/categories_box-english.cache60_64

 

etc.

 

Still have high Current Parse Time: 0.421 s with 551 queries

 

Though AAARRRGGGHHH!!!!

[boxtel]

Another development,

I have been messing around with the cookies settings in configure.php

(domains etc) and now it seems that the cache is working but when I look at the dir using ftp I have loads of files is this correct.

 

Example of cache directory.

 

/tmp/also_purchased-english.cache

/tmp/categories_box-english.cache129

/tmp/categories_box-english.cache21

/tmp/categories_box-english.cache216

/tmp/categories_box-english.cache38

/tmp/categories_box-english.cache39

/tmp/categories_box-english.cache41

/tmp/categories_box-english.cache60

/tmp/categories_box-english.cache60_61

/tmp/categories_box-english.cache60_62

/tmp/categories_box-english.cache60_63

/tmp/categories_box-english.cache60_64

 

 

 

 

etc.

 

Still have high Current Parse Time: 0.421 s with 551 queries

 

Though AAARRRGGGHHH!!!!

<{POST_SNAPBACK}>

 

yes, it will generate a lot of these files. as you can see, for every cpath.

so try to revisit cpath 60 and see if the count goes down.

[boxtel]

yes, it will generate a lot of these files. as you can see, for every cpath.

so try to revisit cpath 60 and see if the count goes down.

<{POST_SNAPBACK}>

 

 

still, this has nothing to do with cookies.

[Guest]

...

After some intensive reading of the boards I have discovered that the cache will not work unless you utilise the Force Cookie Usage in the admin, is this true?

...

<{POST_SNAPBACK}>

Not true but I know where you're coming from. Those with cookies disabled do not use the (box or module) cache and those with cookies enabled only get the cache when it's not expired.

 

and turn off your category count will help a lot.

<{POST_SNAPBACK}>

...always turn off that category count especially if you have lots of categories.

 

Cheers

 

Would I still need to set up the cookie path in configuration.php??

 

<_<

<{POST_SNAPBACK}>

The cookie path will depend on several factors such as location of the osC store within your domain and also whether you have more than one store installed. As a general rule if you only have one store installed the cookie path should be "/" so as to not limit the scope.

 

from you queries I see that you have a huge amount of categories. I would only get the top level ones and only retrieve the sub categories when necessary. Unless you use a DHTML menu ofcourse.

<{POST_SNAPBACK}>

Now, there are alternatives to the DHTML menu. I posted a thread about a CSS driven collapsible category menu that adds 0 queries. This can be adapted easily to ANY store and significantly improves performance over the DHTML varieties.

[rerbe]

Is this a contribution as I would be intersted in utilising this if it speeds things up.

 

Cheers