(Scott Stephens) A general rule of thumb for tuning database applications is “80 percent application, 20 percent database.” This means that, on average, developers can tune 20 percent of performance problems by modifying database parameters, and solve 80 percent of these problems by tuning the a
Other News
Red Hat Linux, Oracle apps travel in style
(Jack Loftus) Who knew penguins loved to travel? And who would have known they did it with Oracle applications on board? (R)
Implementing a relational database using MySQL
(Mark Kaelin) When properly implemented, a relational database can greatly enhance the availability of data and information for an enterprise’s decision makers. However, deploying a relational database on almost any scale requires a thorough understanding of the fundamental concepts and rules that g
Experiencing the power of SQL templates
(Arthur Fuller) SQL Server ships with a variety of templates designed to simplify the most common tasks. The author explains how you can customize these templates, or create new folders in the SQL Query Analyzer folder and populate them with your own templates. (R)
Use Write Caching to Optimize High Volume Data Driven Applications
(Steven Smith) The typical use of caching applies to read caching, or caching data in the application to avoid reading it from the database. However, for applications that must frequently write back to the database, write caching can provide dramatic improvements to performance. This article describ
User-defined functions to generate and apply a table of sequence numbers
(Brian Walker) A table of sequence numbers consists of N rows with each row containing a unique integer value from 1 through N. In some cases it may be more convenient to have the values X through Y where Y-X equals N-1. A table of sequence numbers can be very useful for a variety of purposes. See L
Developers Flock to XML Query Spec
(Darryl K. Taft) A new survey of developers using XML has found that a vast majority are using or plan to use XML Query even before it becomes a standard because of the language’s ability to simplify data extraction.
IBM XML certification success, Part 1
(Hari Vignesh Padmanaban and Pradeep Chopra) This is the first part of a three-part tutorial series designed specifically for those interested in taking the IBM Certified Solution Developer Exam for XML and Related Technologies. Here, the authors help you prepare for the exam with explanations, exam
Simple XML Parser
(Shehan Peruma) The application reads the XML file and then associates the xml tags to variables which are then displayed in a message box.
Basic Threading in Python
(Peyton McCullough) If you want your application to perform several tasks at once, you can use threads. Python can handle threads, but many developers find thread programming to be very tricky. Among other points, Peyton McCullough covers how to spawn and kill threads in this popular language.