Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Optimising a Vanilla Osc


FWR Media

Recommended Posts

Posted

I'm on a bit of an optimisation fest atm.

 

Mainly reducing queries. I'm not taking the "easy option" of deleting functionality (read ANY even if useless .. banners .. vistor count .. cough). Nor am I using a full page cache as it hides bad queries (and maybe oscids .. uggh).

 

I'm wondering what you have got your count down to?

 

Best I've managed so far is 31 when you click on catalog.

Posted
I'm on a bit of an optimisation fest atm.

 

Mainly reducing queries. I'm not taking the "easy option" of deleting functionality (read ANY even if useless .. banners .. vistor count .. cough). Nor am I using a full page cache as it hides bad queries (and maybe oscids .. uggh).

 

I'm wondering what you have got your count down to?

 

Best I've managed so far is 31 when you click on catalog.

 

35 but I've got a ton of contribs installed. Almost all of the improvements came from here.

 

Iggy

Everything's funny but nothing's a joke...

Posted
35 but I've got a ton of contribs installed. Almost all of the improvements came from here.

 

Iggy

 

Yeah me too, Chemo is the proverbial dogs danglies.

 

You say you have contribs installed .. do you have any features removed? banners, visitor counter etc?

Posted
Yeah me too, Chemo is the proverbial dogs danglies.

 

You say you have contribs installed .. do you have any features removed? banners, visitor counter etc?

 

No banner, no visitor counter, no category counts :)

 

Iggy

Everything's funny but nothing's a joke...

Posted
I'm on a bit of an optimisation fest atm.

 

Mainly reducing queries. I'm not taking the "easy option" of deleting functionality (read ANY even if useless .. banners .. vistor count .. cough). Nor am I using a full page cache as it hides bad queries (and maybe oscids .. uggh).

you don't have to remove functionality. Use the cache. If you have seo urls is already there if not you can use it separately.

http://www.oscommerce.com/community/contributions,2873

 

I'm wondering what you have got your count down to?

On cache hits? It can be 0.

Posted

I think I'm being misunderstood here.

 

And Enigma as for advanced cache class returning zero queries that is entirely wrong.

 

The only way to reduce queries down to a few cache calls is to cache a whole page and in my opinion that is a dirty fix and dangerous too (osCids). Also it only works when a customer is not logged in. Also it destroys the dynamic nature of the page.

 

This is why I do not use the page_cache contrib.

 

What I am attempting here is a totally vanilla osc with all functions intact. Reducing the queries in a manner that will positively affect both guests and logged in users.

 

Currently the index page is 30 queries.

 

And the biggest one (clicking on a menu link that has a lot of children) is 36 queries regardless of the number of children.

 

Re: advanced cache class: I am very familiar with it and will probably cache the non dynamic queries (e.g. the table scan for all manufacturers names) .. however this will not reduce queries as the cache will need to query to retrieve the cache. What it WILL do however is turn a table scan into a specific indexed query.

Posted
I think I'm being misunderstood here.

 

And Enigma as for advanced cache class returning zero queries that is entirely wrong.

wrong? why don't you check my store. The response times I believe will be obvious on cache hits vs cache misses. So for example click new products, specials then new products again to see a cache hit. And the shopping cart is fully functional btw.

 

I also mentioned to use "cache". Now the advanced cache class deals with queries only and depends how you're using it and where you're using it. How you're using it depends on the server. With shared servers for instance I would prefer to use the file version of the advanced cache class (which I also customized a bit) as the mysql dbase access could be slower. In which case yea you get no access to the database so no queries.

Posted

TBH to me it seems quite slow (my site is on a US server and I'm UK).

 

Got to say though love the design and tons of work has gone into its unique operation, very impressed.

 

I got lost though, couldn't find my way "home" once I'd gone in and also couldn't find a way "home" from the forum.

 

Top work though!!!

 

I would prefer to use the file version of the advanced cache class

 

Well, obviously that would have no queries.

 

Now the advanced cache class deals with queries only

 

No it doesn't.

 

Basically I used to cache the whole pages and, sure it reduces queries to nothing. But it still is a "dirty fix" and creates problems and a lack of dynamic pages (yes you can put in placers and str_replace them from output buffering).

 

Regarding using files instead of a DB yes they show no queries but there still is server load. Ask yourself whether, for example, forum software is going from DB operation to flatfile or the other way around.

Posted
TBH to me it seems quite slow (my site is on a US server and I'm UK).

 

Got to say though love the design and tons of work has gone into its unique operation, very impressed.

 

I got lost though, couldn't find my way "home" once I'd gone in and also couldn't find a way "home" from the forum.

 

Top work though!!!

Well, obviously that would have no queries.

No it doesn't.

 

Basically I used to cache the whole pages and, sure it reduces queries to nothing. But it still is a "dirty fix" and creates problems and a lack of dynamic pages (yes you can put in placers and str_replace them from output buffering).

 

Regarding using files instead of a DB yes they show no queries but there still is server load. Ask yourself whether, for example, forum software is going from DB operation to flatfile or the other way around.

thx Robert, for the advanced class I meant because the one bobby did uses the mysql you're going to have to access it. So I refered to the dbase access the class did, not what you can store. You can store whatever strings, arrays, text etc. But when you retrieve this content you use the database. If you have the later version it shows you how to process it in files.

 

Why you were looking at the forum that's phpbb not osc. The osc pages are the ones that have the cache implemented. You need to browse a couple of pages like the index or a category, products, specials etc so the cache will have an effect the next time you come around. If the page is not cached you will see no effect. That's why I mentioned on cache hits.

Posted
Why you were looking at the forum that's phpbb not osc

 

Because I have to :D

 

My php days started with Yabbse then onto SMF(Simple Machines Forum) also my website manager (mysitebuilder.co.uk) integrates a forum with it.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...