Languages

Optimize tep_get_tax_rate() method 1.1

Version: 1.1

Downloads:0

Hits:753

SourceNO

Link Broken:Report It!

Package:Without source

Price:$0

More info Download

Description

Problem:Each time a price is displayed on osCommerce the tax rate for that product is queried. Even if the user has set to not display taxes with price the tax rate is queried.Solution:Query for each rate one time as it is needed and then store it in session cache.What this contribution does:This code change will modify the tep_get_tax_rate() method so the first time a tax rate is requested it stores it in session. On every tax rate query it is first checked to verify if it's already in sesssion and if not will query / store in cache. If it is already in session it will return that value and save the database lookup.Result:Reduction in per page query count and faster execution times. Query reduction has been demonstrated to be around 75% savings on some pages.Tested on:8 setups with differing server configurations and osC setup. This change should not affect any other contributions.Install time:As fast as you can open a file, make one change, and upload.

Language: PHP

Related:

Method - Optimize - Optimize Method - Oscommerce Addon - Osommerce Optimize - Tep_get_tax_rate()

User Reviews:

Write Review *
Your name *
Email *
(Your comments will be reviewed by our staff before they are posted)
Rate this product *
Captcha Image
Enter code from image *

 

Related:

payment method depends on shipping method 1.0

 if the shipping is free, you don´t want to offer cod:catalogincludesmodulespaymentcod.

By: addons.oscommerce.com Homepage

Freeware

PlugnPay - API Payment Method 1.0

API Payment Method For SSL Enabled Servers.

By: addons.oscommerce.com Homepage

Freeware

Payment method fee 2.1

This order total allows to add a fee to the order total according to the payment method choosen, and this fee will be shown on the payment page...

By: addons.oscommerce.com Homepage

Freeware

Shipping Method Based On Order Total 1.0

This contribution will allow you to choose the shipping method based on the total order, i.

By: addons.oscommerce.com Homepage

Freeware

Store In Root 2.1

This contribution provides simple instructions for placing your store in the root instead of in the default "catalog" directory.

By: addons.oscommerce.com Homepage

Freeware

jrmc 1.0

Java Remote Method Call provides a Framework for remote method invocation on Java objects which solves the limitations of Java RMI.

By: sourceforge.net Homepage

Freeware

Color Matcher

The Color Matcher makes it available for you to obtain the exact color you want to duplicate. This is possible by the means of Hue, Saturation and...

By: Emery Szasz Homepage

Freeware

Encrypted Password script All

Encrypted Password script All is an article in which users can gather information about protecting their website by password protection with the...

By: Rob Heslop Homepage

Freeware

Eiffelmethod 1.0

This script presents the implemetation of eiffel like methods (methods with preconditions and postconditions).

By: code.activestate.com Homepage

Freeware

Right method names suggestion 1.2

This script uses __getattr__ to modify the error messages given when a wrong class method is called.

By: code.activestate.com Homepage

Freeware