How to increase performance of the page

Question

0.00/5 (No votes)

See more:

Hi,

I have home page where once I Logged in i am redirecting to home page.
I Home page I am calculation text count as per give below

N Text New Status Count Total NText Count % covered Count
P Text New Status Count Total PText Count % covered Count
L Text New Status Count Total LText Count % covered Count

N,P,L are three different table.

Right now there are nearly 2000 records in each table

N and P tables are in relation where i maintaing in NP(4th table) table

IN NP table I have status field where I am calculation New Status Count for N and P
Linked and Approved Status is also there

I already written store procedure for better performanance but still its running too slow. If records will get increse then i think it will slow down.

How can i increase the performanace of the page.

Thanks

sjs4u

Posted 9-Nov-11 21:43pm

sjs4u

Add a Solution

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)

TheyCallMeMrJames · Answer 1 · 2011-11-10T17:38:00

You can't improve the page performance if you are waiting on the database.

You can, however, improve the page experience for the user.

Instead of waiting for the data to render, why don't you instead use jQuery to make a call to a page that will return the results of the database operations. Your page will load quickly, with a pleasant waiting indicator, and then you'll swap out the contents of the "waiting" panel with the juicy bits they're looking for.

Otherwise, look for a way to improve the database otherwise. 2000 records isn't a lot of data. Get better hardware? Use indexes. Only retrieve fields you need. Remember that putting the same code in a sproc doesn't mean it's going to run faster if you haven't optimized the query.