Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
May 30, 1997

Using views to improve performance

Question:
We are building a Web-based interface for an existing database. We're using a SQL interpreter that runs the queries, then sends them to the server without the need for a client side plug-in. Some of the queries take up to 20 minutes to process. The largest table has more than 800,000 rows. Would a view table help the query's performance without slowing down the whole system? What is the deciding factor in using a view table?

Answer:
Performance issues usually are very specific to the data involved, and are best decided using test runs. A view may be particularly useful if you use it to limit the rows that would be processed by a query.

For instance, a view that contains only the rows related to a particular topic would allow you to ask users to select a topic in advance of issuing their query. This would allow you to use the view rather than the base table, improving performance.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date