Script Load Very Slow.

[pokedeck]

Hello I have contacted my hosting for information about my page.

pokedeckshop.com is loading very slow, I tested pagespeed and have over 80% wihich is to good.

 

That is what I talked with my host supporter

 

 

(11:44:23am)Ryan H.:Looks like your script itself takes a bit to load. - Looking like the MySQL queries.

 

lstat("/home/pokedeck/public_html", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0

lstat("/home/pokedeck/public_html/override", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0

lstat("/home/pokedeck/public_html/override/classes", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0

lstat("/home/pokedeck/public_html/override/classes/db", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0

lstat("/home/pokedeck/public_html/override/classes/db/DbQuery.php", {st_mode=S_IFREG|0644, st_size=47, ...}) = 0

time(NULL) = 1362321639

open("/home/pokedeck/public_html/override/classes/db/DbQuery.php", O_RDONLY) = 5

fstat(5, {st_mode=S_IFREG|0644, st_size=47, ...}) = 0

open("/home/pokedeck/public_html/override/classes/db/DbQuery.php", O_RDONLY) = 6

(11:45:02am)joaquin:and the solution is?

(11:45:32am)Ryan H.:To contact a developer and have them optimize your database for you.

 

Do you know how to optimize the database?

huch thanks in advance!!

[vekia]

how many products you have got in your shop?

do you use some external solution (modules?)

[pokedeck]

Hello thanks for reply!!

I have about 500 products aprox.

I have a module to increase my memory from 256 to 512 MB but the site was with same slowness before increassing my memory.

I also used the database connections cleaner... No result.

 

I have cache "system archieves" option habilitated, don't memcache.

 

Really I don't know why this error is occurring.