OS Commerce Mysql tuning

IN PROGRESS
Bids
19
Avg Bid (USD)
$681
Project Budget (USD)
$200 - $1250

Project Description:
We are looking for a Mysql/PHP expert who can help us with following tasks:

- Analyze the current database for indexes / mysql settings
- Depending on the analyze tweak mysql settings or upgrade to mysql cluster
- Rewrite long time taking mysql queries

The database is used for an online webshop based on OS Commerce v2.2 RC2a
.
All the code is customized because we changed the backend database to a multi-supplier and auto selection rule platform.
In total we have more then 350.000 different products with around 600.000 prices linked to it.



Required skills:
Mysql Expert, Linux, PHP, Apache

Additional Project Description:
05/23/2012 at 5:36 PET
Hereby some more information the OS Commerce Platform

Database structure:

Table: Products
Fields: products_id, manufacturers_id, categories_id, ...

Table: Products_supplier
Fields: id, name, enable, priority, import, cost, products

Table: Product_to_suppliers
Fields: suppliers_id, products_id, quantity, price, fee1, fee2, fee3, fee4

Table: Products_description
Fields: products_id, language_id, ...

Table: Manufactures
Fields: manufacturers_id, manufacturers_name, manufacturers_image

Table: Categories
Fields: categories_id, categories_image, parent_id, sort_order, date_added, last_modified

Table: products_to_margin
Fields: id, manufacturers_id, categories_id, min_value, max_value, value, import_type


Flows:
See visio design in attach

Todo:
- Improve the sql queries and PHP code to receive the price for a specific product
- Improve the sql queries and PHP code to find promo products

Skills required:
Apache, Javascript, MySQL, OSCommerce, PHP
Additional Files: Drawing1.vsd
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.