IS there METHOD caching?

[alexk345]

I have 100000 combination per product. Each time prestashop looking for products it go through all this combination. One time its ok. Not everytime. This results has to be cached. Especially sql intensive methods with for loops.

 

These things do not change even pricing. Once set ..or when ever there is price update cache can be rebuilt by running all prodduct URL at one time.

 

SQL you can say SQL_CACHE...we need something infront of methods. or even smarty should have method caching.

 

I feel prestashop slow massively for more than 3000 combinations.

 

I was able to fix product page ,..cart etc. But i still think these pages can be speeded up without using major cache.

 

You can call method caching like micro caching.

Edited July 4, 2015 by alexk345 (see edit history)

[Dh42]

That could be done, you could use a memory cache layer in front of your database as well. That is why I recommended you that module when you first mentioned the problem. It solves this by changing the whole way that attributes work in PrestaShop. 

[alexk345]

I am not spending 1 cent on any modules.I  can develop things if i have sufficient time. I see a business in that people promoting modules than answering question. There is a reason prestashop not famous. One reason is that i can buy modules 10-20 for wordpress just save time. Here modules are expensive,. its not cost that is the issue. Its core has problem modules won't work. Modules also not fully tested and each one have their own business issues. So one module do not fit everyone issue. 

 

I finished my shipping module and unlimited combination issue with prestashop in a week already.

next few days i am working on speed issue with prestashop . mainly trying to find bottle neck. Because my site has only header and footer and some product categories...it should show site in a flash without cache. 

 

So basically prestashop frame work has too many checks. I tested my vps ssd server with my custom files its response is lightening speed. So its just prestashop routing and stuff.

 

I saw one place you can disable combination. But it also disable s products as well. SO not implemented correctly.

 

public static function isFeatureActive()

{

static $feature_active = null;

 

if ($feature_active === null)

$feature_active = Configuration::get('PS_COMBINATION_FEATURE_ACTIVE');

return $feature_active;

}

 

My plan is disable combination everywhere except product page to speed things up. But product listing do not show..i may have to hack categories product listing...anyway i am just digging through.

 

If there is method cache..i just can set flag in source code itself. Some method results are static even with few argument change...like prdoucts inside each category.

 

These things slows prestashop badly. I need to check cart display too see how it slows down

 

Home page

1. Categries 

2. Cart display

 

Those tow use database. And those calls should be optimized to show home page display lightening fast.

[Dh42]

I think your whole out look is kind of funny to be honest. I am guessing that you do not charge very much an hour or might not being doing this professionally for a living. Our hourly rate is between $87 and $150 an hour depending on what we do. The way most professionals in the industry look at it is like this. I can either purchase that module and have everything done in 2 hours. Or I can spend 2-3 weeks writing something to do it. You have wasted 2 weeks already and you haven't finished it. So your time is worth less than $75 a week? Interesting. 

 

 

You can disable combinations, yes, but it disables the products that use them too. So that is really not an option. 

 

The new version 1.6.1 that came out last week, you might check it out. It has drastically reduced these Mysql calls and extra checks. 

[alexk345]

hi

 

May be that is your shortcut. if it work for you that is great!. awesome. 

 

I have different route. Its harder way. I like to build things on my own. I just wanted to see how prestashop build , how is its support. Unless you work on project its not easy to see how many using this cart. 

 

I think i do not see anyone here reply properly. All say buy this , buy that. Problem solved. I do not think so.

 

Also whole idea of me posting here to find people like me who hack around and find anything useful. I  just made prestashop  super fast.

 

I was looking for people who are new to prestashop , i am not going to sit here take away your income. Once this  project is done..no more of prestashop.

 

My next project have to be another shopping cart.

Edited July 5, 2015 by alexk345 (see edit history)