hi
i have a website like
www.mysite.com
which is on USA machine both webhosting and database when i open my site huge reports open fastly because both are on same machine.
But on other side when i have offline asp.net pages with 1.1 and connecting with Online USA server like (64.6.5.121 etc) then the speed is v slow because database on other machine and pages on my machine.
what is solution for improvement????
i have also fast DSL...
Please??????
Hi,
Put your database server on the same ASP.NET is the best idea!
If you must run your db in different location, you can caching your database connections or usingConnection Pooling
and you can even cache your data from db like this:
http://www.2enetworx.com/dev/articles/caching6.asp
There is other tips that you can try, check the Network Bandwith and Database issue section of
http://www.15seconds.com/issue/000106.htm
for more details!
hope it helps!
0 comments:
Post a Comment