Slow queries execution time with asp

Question

2.00/5 (1 vote)

See more:

I have sql server and IIS on the same virtual private server. I am running both asp and asp.net applications over same database.
Asp.net application is working as expected, but I have problems executing queries with asp application. Some of the queries are executing much slower than expected. Even when I am using only asp nothing changes. Anyone knows what can cause this?

Posted 29-Apr-13 9:06am

stoores

Add a Solution

Comments

Sergey Alexandrovich Kryukov 29-Apr-13 15:12pm

ASP or ASP.NET? They are not really related, ASP.NET is not a kind of ASP, did you know that?

You did not provide any useful information to help you. You might review your indexes, you queries, even your database schema. Too many factors may affect performance...

—SA

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ordun · Answer 1 · 2013-04-29T09:40:00

Solution 1

Can’t help much without any query code provided but sometimes you just need to experiment. Try changing referencing instances to use IP address instead of server name or just move everything to asp.net.

Posted 29-Apr-13 9:40am

Ordun