Sensors and network administering


sensornet-work.com keyword stats



Most current Google search phrases:

telnet 1723 spped test
winxp ttcp.exe pptp ping windows xp
how to telnet to port 1723 get connection speed from asp.net
speedtest/charter.net ldap query 3268 failure
wwww.speakeasy.net old tv test pattern
speedtest.charter.net TV Test pattern
cable spped test speedtest.zoominternet.net
dns query in udp syntax check verizon internet speed
charter spped test Internet Sped Test
check spped test verizon spped test

Optimizing Your Asp.Net Pages For Faster Loading And Better Performance

If you read the internet and all of thewhich then in turn needs to be looped through
websites dedicated to Asp.Net you willto obtain your data. So instead of writing
inevitably read about the wonders of theyour stored procedure like the following
DataGrid, DataList, and Repeater controls.which brings back 1 result set:Select Title,
While each of these has its place, if you areBody, AuthorFrom ArticlesWhere ArtID = 215We
only displaying data there is a much fastercan write it using a set based command like
and more efficient means to do so.Let's saythis.Create Procedure mysp_GetArticle@Title
you have a page that displays articles basedvarchar(200) Output,@Body varchar(8000)
on a query string. Take my article pages forOutput,@Author varchar(500) OutputAsSelect
instance. Each article is stored in a@Title = Title, @Body = Body, @Author =
database and displayed on the page based onAuthorFrom ArticlesWhere ArtID = 215GOThe
the unique id of the article as stored in theabove query will return only the three
database.A normal asp page executionparameters called for and not a result or
procedure goes something like this. The coderecord set so you don't have to then walk
queries the database based on the Articlethrough the returned record set that has only
I.D. and then brings back that information to1 result in it anyway. This second little
the page where you display it in the fashionprocess of work decreases your performance so
that you would like. This is a fairlyyou should avoid it whenever possible.
straight forward approach with asp and isCombine this technique with the asp.net
done all the time.So how do we speed up ourcache.Number 4: Use Classes and ArrayLists as
asp.net pages?Number 1: Use Asp.Netopposed to returning an SqlDataReader.Create
Caching!This is a no-brainer, and I won't goa class and then if there are more than one
into the brilliance or details of asp.netset of results store those results into
caching here because at the time of thisindividual instantiations of that class.
writing Google has 2,780,000 articles on theFinally store each of those classes into an
topic. Basically instead of querying theArrayList. You can then store only that
database each time the page is loaded youArrayList into the asp.net cache. So instead
only query the database once and load thatof getting the results back from a
result into the system cache. SubsequentSqlDataReader when loading your page you get
calls to load the page retrieve the data fromthem from the ArrayList which is stored in
the cache as opposed to the database whichthe cache. Nice huh?Finally... you want to
gives you an instant and considerableincorporate all of these techniques into your
performance boost. You can then set the cachefinal results which would be performed in the
for how long the cache should store thefollowing manner and sequence.On the first
information as well as many other features.time the page loads, query the database and
If you are not using the cache, you should bereturn all of your data storing it into
whenever possible!Number 2: If possible, doindividual classes. Then store each of those
NOT use the standard Asp.Net controls.That'sclasses into an ArrayList. If you only have
right. The standard asp.net controls areone single result you may store only the
designed for rapid development and not pageclass into the cache. Then take your
performance. They allow you to design pagesArrayList and store it into the cache.Next
that grab and display data very quickly butcreate a Web Custom Control and pass the
their actual performance suffers because ofcached ArrayList to the custom control and
the extra overhead which is there for easeloop out your data using the HtmlTextWriter
and speed of development time and not pagewhich is very fast. Remember each subsequent
execution speed.Instead, create either a Usercall to load the page will be called from the
Control or even better yet a Web Customcache which stores your ArraList of classes
Control which is by far the fastestor your single class.Certainly it takes a
performance wise and really quite easy tosignificant amount of additional coding to do
create and use.Number 3: Use an SqlDataReaderit in this fashion, especially when you take
or even better yet use a set based commandproper error handling into consideration, but
for Sql Server data retrieval and simplyif you follow this approach your pages will
execute that one command against thebe screeching fast, you will immediately
database.An asp.net SqlDataReader is a fastnotice the difference, and your asp.net pages
forward only datareader that closes thewill execute in the proper sequence - Data
connection after it reads the last set ofhandling in the Page_Load function and the
results. Now for my article pages we are onlyhtml display in the Page_Render
returning 1 particular result. In this casefunction.Further, you will be glad you did
we would opt for the set based command. Ifand so will your visitors.Happy
you had more than 1 result returned, in yourProgramming!John Belthoff is an avid web
table of contents for instance, you would usedeveloper who writes about Asp.Net in his
the SqlDataReader because you are returningspare time. He owns a Windows Asp.Net, Asp
multiple sets of results.Set based commandsWeb Hosting Company where you can contact him
are stored procedures that bring back dataabout hosting your website/blog or just to
through parameters as opposed to a result setlearn more.



1 A B C 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95