Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

Web Database

I have a website, which has SQL server express database it is about 20 tables with about 10,000 records. The database has very less transactions most of the loads are coming from select as too much user opening the website.
Now I have a lot of traffic on the CPU of the server what do you advise me to reduce some load on the database.

0
Yadtrt
Asked:
Yadtrt
  • 3
  • 3
1 Solution
 
gplanaCommented:
See if you have index for the columns you are using to filter on the select (i.e. the columns that appear on the where clause). This would improve a lot the performance.
0
 
gplanaCommented:
Have you tryied what I have told to you about indexes ?
0
 
YadtrtAuthor Commented:
I know this before I post the question, index is not fragmented as there is no transaction in the database.
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
YadtrtAuthor Commented:
The problem was from a view which the relation was broken and it became a crossjoin
0
 
gplanaCommented:
ok, then if you have solved the question yourself, you can assign the points directly to you. I think this is better than delete question, so the solution will be published.

Regards
0
 
YadtrtAuthor Commented:
that was the solution I found it my self
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now