Monthly Sales & Tax Report

This is a discussion on Monthly Sales & Tax Report within the New osCommerce Contributions forums, part of the osCommerce 2.2 Forums category; - SQL query upgrade When you have allot of order and order products in your DB then this report becomes ...

		osCommerce and osCMax shopping cart software forums > osCommerce 2.2 Forums > New osCommerce Contributions
Monthly Sales & Tax Report

11-29-2007, 02:31 PM

michael_s

osCMax Developer

Join Date: Jul 2002

Location: Phoenix, AZ

Posts: 11,100

Thanks: 81

Thanked 348 Times in 327 Posts

Rep Power: 10

Monthly Sales & Tax Report

- SQL query upgrade

When you have allot of order and order products in your DB then this report becomes very slow. In my case it took more then 3 hours!!! Now for me its a little more then 10 seconds. It still can be done better but for me its fine now.

More...

__________________
Michael Sasek
osCMax Developer

Read my osCMax Blog - Keep up to date on what is happening with the project.

osCMax Templates - Hundreds of premium quality templates designed for osCMax 2. Loyalty discounts up to 30% off!
Each purchase supports the osCMax project with much needed funds!
xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience.
osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host. Default multi server configuration for exceptional performance!
osCMax Template Tutorial - Learn how to make your own custom templates and how to use the powerful features of the osCMax template system.

Sponsored Links

osCommerce and osCMax shopping cart software forums

« Christmas Template | Sloppy Words Cleaner »

Thread Tools
Show Printable Version Email this Page

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Monthly Sales Report	michael_s	New osCommerce Contributions	0	09-19-2007 05:25 PM
Manufacturer Sales Report	michael_s	New osCommerce Contributions	0	05-23-2007 09:21 AM
Manufacturer Sales Report	michael_s	New osCommerce Contributions	0	05-23-2007 08:46 AM
Manufacturer Sales Report	michael_s	New osCommerce Contributions	0	05-22-2007 10:37 PM
Sales Report 2	michael_s	New osCommerce Contributions	0	01-31-2007 04:03 PM

All times are GMT -8. The time now is 09:07 PM.

Shopping Cart Software

Monthly Sales & Tax Report

Monthly Sales & Tax Report

Similar Threads