OS Commerce Mysql tuning
Ngân sách $200-1250 USD
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
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
17 freelancer đang chào giá trung bình $702 cho công việc này
Hi, We have throughly read your requirements and believe that we can deliver exceptional results. We hope you will consider using our services. Best Regards,
Hi! I am really interested in taking up the project. I have the requisite experience and the expertise to complete this project with success. Please view my PM for details. Thanks. Regards. GLOBAL TECHNOSYS
Hi We could do as per your requirement. u could check that out. we would work till your satisfaction. -- Please check inbox for our previous work.
Hi, I have been building and running osCommerce sites for years so can get this done for you. Thanks,
Hi , I have read your requirements and I have done really similar projects. I would like to work with you on this project. Please check your inbox for more information about us and our most recent projects.
Dear Sir, Greetings! We are Reform Consulting with 5 year of experience under our belt. We are really interested to work on your project. Please see PM. Thank you. Regards, RCPL.
Hi , we appreciate and thank you for sharing your requirements. We are a team that knows the integrity of design and develop a website and with the following links you can have the idea. [url removed, login to view] Thêm
My experience as a SQL developer and queries optimization recommend me for the job. Over the past 5 years, I've designed and optimized SQL statements for various database types in production environments.