We need a good and experienced DLE specialist.

Employer
[no-member:pro]Aleksey[/no-member:pro]Aleksey
Project parameters
Type of cooperationPeriodic employment
SectionWeb development
Prepaymentwithout prepayment
Payment methodsElectronic money
Acceptance of requestsclosed
Project description
Hello, there!
My problem is this. The site in 2009 was written by a crivorukim "student of a doctor". As a result, I have a lot of problems today because It requires optimization, revision, etc., not counting even if not particularly critical purely functional bugs and flaws.
Here's my host asking me to describe the problem, and yesterday I wrote:
Non-optimized queries that do not caches MYSQL or without index requests. It's Hindu code, the crooked hands of a programmer. It works, it works. The fact that the request is executed for 11 seconds, no one cares.
Since 18 hours yesterday, heavy requests have been processed 52333
And 11 seconds requests, 112. In general, if the request is executed longer than 0.1 - 0.2 seconds, optimization, revision of the database structure, etc. is required. Activities.
Here is an example of an 11-second request:
# User@Host: nhtnb136_bsd[nhtnb136_bsd] @lochost []
#Query_time: 11.685426 Lock_time: 2.390779 Rows_sent: 5 Rows_examined: 151370
SET timestamp=1488406145;
SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.category, p.alt_name, p.comm_num, p.allow_comm, p.fixed, p.tags, e.news_read, e.allow_rate, e.vote_num, e.votes, e.voedit, e.quo, p.com, p.alt_edit, p.l_edit, p.com, p.com, p.l_ed, e.dex, e.d.com, e.d.d., e.d.com, e.d.com, e.d., 01;d.d.d., 01;d.d.d., EDED., : ED., ED., ED., : ED. ED., ED. : : ED. 01;d. ED. ED. ED. ED. : : ED. : ED. ED. : : ED. : : ED. : ED. ED. ED. : 01: ED. ED. ED. ED. ED. : ED. ED. : : ED. : ED. ED. ED. : : ED. ED. ED. : : ED. ED. ED. : ED. ED. ED. ED. : ED. ED. : : : ED. : : ED. ED. : : ED. : : : ED. ED. ED. ED. 03////////////////////////////////////////////////////
Also, last month I wanted to install an SSL certificate on the site (in general, I have 3 such sites, but alas, when all the work on registration and installation of the certificate by the hoster was done, it turned out that the links in the templates are direct, and therefore all pages are not with a green icon in the address bar next to https, but with a yellow one, as not protected. In addition, the video on the pages of sites posted from YouTube, ceased to show.
I would like to ask you if you have really high-class DLE specialists and can you do this work? What would be the approximate cost?
I think it will be much easier to just create a new website and import all the data from the old one (to make a copy on the latest version of dle - it is official). The site is simple, standard features and capabilities.
I know for myself that it is easier to do everything as needed and correctly from scratch than to rule other people's joints.
With respect, Alexei.
My problem is this. The site in 2009 was written by a crivorukim "student of a doctor". As a result, I have a lot of problems today because It requires optimization, revision, etc., not counting even if not particularly critical purely functional bugs and flaws.
Here's my host asking me to describe the problem, and yesterday I wrote:
Non-optimized queries that do not caches MYSQL or without index requests. It's Hindu code, the crooked hands of a programmer. It works, it works. The fact that the request is executed for 11 seconds, no one cares.
Since 18 hours yesterday, heavy requests have been processed 52333
And 11 seconds requests, 112. In general, if the request is executed longer than 0.1 - 0.2 seconds, optimization, revision of the database structure, etc. is required. Activities.
Here is an example of an 11-second request:
# User@Host: nhtnb136_bsd[nhtnb136_bsd] @lochost []
#Query_time: 11.685426 Lock_time: 2.390779 Rows_sent: 5 Rows_examined: 151370
SET timestamp=1488406145;
SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.category, p.alt_name, p.comm_num, p.allow_comm, p.fixed, p.tags, e.news_read, e.allow_rate, e.vote_num, e.votes, e.voedit, e.quo, p.com, p.alt_edit, p.l_edit, p.com, p.com, p.l_ed, e.dex, e.d.com, e.d.d., e.d.com, e.d.com, e.d., 01;d.d.d., 01;d.d.d., EDED., : ED., ED., ED., : ED. ED., ED. : : ED. 01;d. ED. ED. ED. ED. : : ED. : ED. ED. : : ED. : : ED. : ED. ED. ED. : 01: ED. ED. ED. ED. ED. : ED. ED. : : ED. : ED. ED. ED. : : ED. ED. ED. : : ED. ED. ED. : ED. ED. ED. ED. : ED. ED. : : : ED. : : ED. ED. : : ED. : : : ED. ED. ED. ED. 03////////////////////////////////////////////////////
Also, last month I wanted to install an SSL certificate on the site (in general, I have 3 such sites, but alas, when all the work on registration and installation of the certificate by the hoster was done, it turned out that the links in the templates are direct, and therefore all pages are not with a green icon in the address bar next to https, but with a yellow one, as not protected. In addition, the video on the pages of sites posted from YouTube, ceased to show.
I would like to ask you if you have really high-class DLE specialists and can you do this work? What would be the approximate cost?
I think it will be much easier to just create a new website and import all the data from the old one (to make a copy on the latest version of dle - it is official). The site is simple, standard features and capabilities.
I know for myself that it is easier to do everything as needed and correctly from scratch than to rule other people's joints.
With respect, Alexei.