QA

IOTA^_^    

Sams Teach Yourself ASP.NET in 21 Days, Second Edition
By Chris Payne
Table of Contents
Day 12.  Employing Advanced Data Techniques


Q&A

Q1:

How do transactions roll back data?

A1:

A database maintains what is known as a transaction log. This log keeps track of all the statements that are executed and the data that has changed. The database refers to this log to determine the state of the data before the statements were executed, and moves back to that state if necessary. If necessary, a transaction log can even be used to regenerate an entire database.

Q2:

How much of a performance benefit do stored procedures actually provide?

A2:

That's difficult to say. It depends on the database application you're using and the commands being executed, among other things. Studies have shown, however, that using stored procedures can result in up to a 25% decrease in processing time. For more information, check out the article at http://www.4guysfromrolla.com/webtech/sqlguru/q120899-2.shtml.


    IOTA^_^    
    Top


    Sams Teach Yourself ASP. NET in 21 Days
    Sams Teach Yourself ASP.NET in 21 Days (2nd Edition)
    ISBN: 0672324458
    EAN: 2147483647
    Year: 2003
    Pages: 307
    Authors: Chris Payne

    Similar book on Amazon

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net