This is the second of four articles about Database Management Systems’ (DBMS) performance. The first of these four articles presented an overview and some installation tips. The article you are now reading talks about building the database’s tables and indexes. Parts three and four get into the meat of accessing the database, with non-SQL tips [...]

Website Performance: Taxonomy of Tips intro­duced a clas­si­fi­ca­tion scheme to help us or­ga­nize the many per­for­mance tips found on the In­ter­net.  In Emp­ty Src and Href At­tri­butes, Com­po­nent Caching, and Image Processing for Performance, we ex­a­mined tips that af­fect the “jour­ney from the ser­ver to the cli­ent.”  We wrap up this dis­cus­sion today by sum­ma­riz­ing [...]

Web­site Per­formance: Tax­o­no­my of Tips in­tro­duced a clas­si­fi­ca­tion scheme to help us or­ga­nize the many per­for­mance tips found on the In­ter­net.  My fol­low­ing three ar­ti­cles re­viewed the tips that af­fect the re­sponse’s jour­ney from the ser­ver to the cli­ent cat­e­go­ry.  To­day’s ar­ti­cle be­gins the dis­cus­sion about the syn­chro­ni­ci­ty cat­e­go­ry.

Like it or not, your end-users will judge your website.  If, in their judgment, it is perceived to be slow, that judgment will partly determine how often they return.  It will also affect their friends’ decisions insomuch as user experiences are shared.  That’s why monitoring the user experienceis so important.Now on to the next step.  [...]