Support and improvement of the web application

1. Support and improvement of the web application

Vylegzhanin Roman
Computer Science Department
Voronezh State University

2.

Improving the client part
Optimization of the server part
Database refactoring

3. Improving the client part

4. The need of well-crafted UI

5. Optimization of the server part

6. Server optimization problems How to

Make server
Simplify procedure
run faster
of debugging

7. Solutions

Getting rid of repetitive code sections
Partitioning large modules into submodules

8. Database refactoring

9. Database refactoring

Structure of database
Writing queries

10. Incorrect database structure

11. Correct database structure

12. Writing queries

Table “A”
Table “B”

13. Writing queries

1. SELECT … FROM (A * B)
WHERE STREET = “BAKER”;
2. SELECT … FROM A *
(SELECT ... FROM B
WHERE STREET = “BAKER”);
O(N2)
O(N)
N times less time

14.

Improving the client part
Optimization of the server part
Database refactoring

15. Support and improvement of the web application

Vylegzhanin Roman
Computer Science Department
Voronezh State University