ASP.NET Web Forms


















ASP.NET Web Forms Databases Web Development

Using SqlDataReader NextResult to improve performance

by John Avis | July 31, 2014
On database-driven websites it is commonplace to execute multiple database queries to generate just one page. For example, on the home page of an ecommerce website you might get a list of categories, a list of banner advertisements to display, a list of featured products, and a list of top selling products. I investigate whether it was more efficient to put these multiple queries into one stored procedure and use the SqlDataReader's Next Result method to get the data all in one go.








ASP.NET Web Forms Web Development

Custom 'Fuzzy' search system in ASP.NET

by John Avis | June 19, 2013
Many or perhaps most websites have the need for a search facility to search the website content or other things like products. Ideally you want an intelligent search, a bit like a search engine, where search results are ordered by relevancy, misspellings are tolerated, and maybe even word stemming is used (so a search for "teach" also returns results for "teacher", "teaches", "teaching", "taught", etc).









Tags

About me

...random postings about web development and programming, Internet, computers, electronics and automotive topics.

Subscribe

Get the latest posts delivered to your inbox.