Languages

Optimize tep_get_tax_rate() method 1.1

Version: 1.1

Downloads:0

Hits:782

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:

PlugnPay - API Payment Method 1.0

API Payment Method For SSL Enabled Servers.

By: addons.oscommerce.com Homepage

Freeware

Default Selected Shipping Method 1.0.1

Choose the shipping method default selected in the checkout_shipping.

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

TNT Express shipping method 1.0

This simple contribution is usefull to add TNT express shipping method in your site.

By: addons.oscommerce.com Homepage

Freeware

ImageEn Addon 1.1.0

ImageEn Addon is a package of graphical components for Delphi and C++Builder. For example the package contains components for reading and writing...

By: Wijffels

Shareware

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

Decorator for main method 1.0

Decorator for main method script shows how to do the same thing with a decorator that makes the code much cleaner.

By: code.activestate.com Homepage

Freeware

High-performance currying with instance method 1.0

This script implements the instance method for performing currying.

By: code.activestate.com Homepage

Freeware

Obtaining the name of a function/method 1.0

This scripts shows you how to obtain the name of a method or a function from within the running method/function.

By: code.activestate.com Homepage

Freeware