You have chosen to sponsor your bid up to a maximum amount of .
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.
Mysql Expert, Linux, PHP, Apache
Additional Project Description:
05/23/2012 at 5:36 PET
Hereby some more information the OS Commerce Platform
Fields: products_id, manufacturers_id, categories_id, ...
Fields: id, name, enable, priority, import, cost, products
Fields: suppliers_id, products_id, quantity, price, fee1, fee2, fee3, fee4
Fields: products_id, language_id, ...
Fields: manufacturers_id, manufacturers_name, manufacturers_image
Fields: categories_id, categories_image, parent_id, sort_order, date_added, last_modified
Fields: id, manufacturers_id, categories_id, min_value, max_value, value, import_type
See visio design in attach
- 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