Devam Ediyor

OS Commerce Mysql tuning

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

Beceriler: Apache, Javascript, MySQL, OSCommerce, PHP

Daha fazlasını gör: php tuning, php mysql online help, mysql tuning, TUNING, os commerce, mysql linux php, help us upgrade, database tuning, cluster, auto supplier, apache javascript, webshop mysql, 350 products, apache commerce, rewrite rule, multi platform online database, mysql cluster apache, linux php upgrade, multi upgrade, mysql platform

İşveren Hakkında:
( 6 değerlendirme ) Asse, Belgium

Proje NO: #1648649

Bu iş için 17 freelancer ortalamada $702 teklif veriyor

kagg

Please refer PM for experience in oscommerce and similar projects. Thanks.

in %bids___i_period_sub_35% gün içinde600%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(291 Değerlendirme)
8.0
SunrisePHP

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,

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(587 Değerlendirme)
7.4
globaltechnosys

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

in %bids___i_period_sub_35% gün içinde1000%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(124 Değerlendirme)
7.3
CoVaLiDiTy

can help you. tnx.

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(299 Değerlendirme)
7.0
madeureka

Oscommerce pro, ready to help you, great project and a real challenge.

in %bids___i_period_sub_35% gün içinde1000%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(109 Değerlendirme)
6.4
tonykim100

Hello sir! Please check PMB.

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(128 Değerlendirme)
6.3
techwelfare

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.

in %bids___i_period_sub_35% gün içinde880%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(61 Değerlendirme)
6.3
piaoxin

Plz check my PMB.

in %bids___i_period_sub_35% gün içinde1000%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(31 Değerlendirme)
5.5
binhtq

Hi, I have been building and running osCommerce sites for years so can get this done for you. Thanks,

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(19 Değerlendirme)
5.0
itamarjp

I can optimize it.

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(43 Değerlendirme)
4.9
univane

Hi, We are expert in oscommerce and can help. Kindly reply for references. Thanks, Univane

in %bids___i_period_sub_35% gün içinde600%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(22 Değerlendirme)
4.4
ecommercemaestro

Hi, I am master of [login to view URL] view PMB for more detail.

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)
4.3
liuxinran

Hi I can do this. Please check the PM.

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(15 Değerlendirme)
4.1
koredeola

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.

in %bids___i_period_sub_35% gün içinde1100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
0.0
reformconsulting

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.

in %bids___i_period_sub_35% gün içinde700%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
4.4
bctechnosys

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. [login to view URL] Daha Fazla

in %bids___i_period_sub_35% gün içinde1200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
2.8
something9999

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.

in %bids___i_period_sub_35% gün içinde800%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
K5Y7WGha0

Custom software development - <b><i>Removed by Admin</i></b>

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0