aceess speed issue over the internet

ya it does happen when i directly acces fro server that time aslo i have the same hits that i have when accessing over the net

You are not getting my point completely Please understand properly what i mean

If your code or design has problem in RDP also it should work slowly as on internet.

If in RDP it works fine then the problem is in bandwidth. Hope you get my point

RDP is remote desktop right

wht u said i  understood but  the authorities are not convencied

i hope u understand wht i am saying. they can see that the speed of the  application is slow & the only reason they understand the reason is the code , the work

the page is datacenteric every click hits the database

so just trying to figure out that if somehow the datbase hits to the server are reduced it may increse the speed

with regards to same other than stored procedure wht else is the way

Do the following

1. Do RDP to server check performance

2. Access site from internet and check performance

If #1 and #2 both yield same results then code has problem

Otherwise it can be following

1. Heavy images

2. Low bandwidth from server

3. Slow internet