How to increase the page loading speed of the site when the selection form is based on the database?

K

keslo2016-04-04 20:44:39

SQL

keslo, 2016-04-04 20:44:39

Hi Hi!
The site is made on www.advantshop.net
Site disk4you.ru
Pages are loaded statically tolerably. But here are the pages with the selection (there is a selection on the main page), for example, here ... The server response comes in 10-15 seconds, judging by the service data .
Is it possible to increase the response speed of the site when selecting? For example, by rewriting the query code to the database? etc.
- Selection from the database on the server where the site is.
- VDS hosting on 1gb.ru
- About 3000 positions in the database

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

R

res2001, 2016-04-04
@res2001

Make the correct indexes in base.

A

Alexey Zazimko, 2016-04-05
@leroy_mackoy1

How is the db access going? via EF?