Explore the problem in the partner program and optimize the script

Desktop Apps, PHP — incorrectly specified categories?

67 USD

Client's review of cooperation with Dmitry Goncharenko

Explore the problem in the partner program and optimize the script

67 USD

The assigned task was fulfilled. Time will clearly show how good it is, but for now everything works very well.

4.8

Denis Kornychuk

Reciprocal Feedback

5 March 2019

Freelancer's review of cooperation with Denis Kornychuk

Explore the problem in the partner program and optimize the script

67 USD

The client set the task, but gave access only to those files that are not used by the engine. As a result, the work was done, but on the unused files and the person began to complain that the work was not done( the pages were not optimized). After all the explanations, the customer refused to provide access to the admin and the current files of the site, argumenting this by the fact that there everything is encrypted. In general, I asked for access to the admin and bd, and finished work by changing the code through the admin. I will not cooperate with him anymore. Except for support and advice on the work of my code.

2.4

Dmitry Goncharenko

Reciprocal Feedback

5 March 2019

Project translated automatically. Log in or register, to view the original A partnership program is implemented.The essence of the work is like YouTube, the partner is charged money for the amount of advertising made in the video player.Over time, it has become very long loaded (in the user) the personal office page, and also a very long passage to the statistics page (page download time 23-27 seconds.)After analyzing the problem, we found that during logging and moving to the statistics page in mysql there is a large number of requests to the partner_visit table, the innodb size of the table almost 400 MB.Questions of this type: SELECT COUNT(id) FROM partner_visit WHERE deleted=0 AND partner_id=3 AND action='advert' AND time>='2019-05-01 00:00:00' AND time'2019-06-01 00:00:00' Each of the requests processes in 1-2 seconds and they process in a row Number of lines in the partner_visit table number of lines ~4,949,173 and this is the fact that there is only one user (test).It’s terrible to think about what will happen with a large number of users.Task: Maximally optimize the script of the partner program to reduce the load, to the fastest page load speed.Also analyze the script, if necessary optimize under large loads.

Proposals 3 Withdrawn 1 Rejected 3

Please select

Andrey Kovalchuk

0 0

Projects -
Rating -
Rating 160

Budget: 3000 UAH Deadline: 2 days

Good day . I do it quickly and professionally. I specialize in data and SQL optimization.

Artem Ilchenko

21 0

Projects 9
Rating -
Rating 565

Budget: 3000 UAH Deadline: 1 day

Hello, ready to help, have a great experience of optimizing SQL requests

Dmitry Goncharenko

Winning proposal

109 4

Budget: 3000 UAH Deadline: 3 days

Good evening . The main problem lies in the poorly thought of the logic of the partner program. If only one user can create 5 000 000 lines in the table, then your program may be considered unfunctional.