web analytics

Data, data everywhere 

Twitter LinkedIn RSS
magnify
Home Archive for category "Performance analysis"
formats

Performance overhead of SQL user-defined functions

Some time ago I wrote an article that described the performance tradeoffs one encounters when using SQL user-defined functions – sometimes called UDFs or PSM (Persistent Stored Module) functions – from within an SQL query. In that article, I wrote: A recent email exchange with software consultant Breck Carter regarding the performance of user-defined functions

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

What exactly is thread deadlock?

Performance testing is a key component of system testing, since a non-performant application is often viewed as just as poor as an application that contains other varieties of defects. Care and attention are required to ensure that even simple processes will not cause contention in a production environment – and sometimes these issues are difficult

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

How to give a query optimizer fits

Recently I have been interacting with a number of people, including Lukas Eder of JOOQ and consultant/blogger Vlad Mihalcea, on SQL and its merit as a query language, particularly with respect to object-relational mapping frameworks such as Hibernate. With native HQL, or with JPA’s JPQL language, Hibernate is responsible for creating the SQL query passed

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Schema design tools are a tough challenge

Recently I was in Lausanne, Switzerland at EPFL, acting as one of the examiners for Ioannis Alagiannis’ PhD thesis defence. Yannis is a student of Natassa Ailamaki, whose work in database systems I’ve long admired. Yannis’ thesis surrounded issues surrounding NoDB – the idea of having a DBMS perform query processing over raw data files,

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

CFP: Sixth Workshop on Big Data Benchmarking (WBDB 2015)

The Sixth International Workshop on Big Data Benchmarking will be held in Toronto, Ontario at the University of Toronto on 16-17 June 2015. The WBDB workshops are designed to make progress towards the development of industry-standard benchmarks for evaluating hardware and software solutions for big data applications. Topics to be discussed at the Workshop include,

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Set-level operations do matter

A recent email exchange with software consultant Breck Carter regarding the performance of user-defined functions in SQL has prompted me to re-post this article that I originally wrote in 2008. User-defined functions in SQL have their uses; unfortunately their performance characteristics are highly variable because it is very difficult impossible for a query optimizer to

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
1 Comment  comments 
formats

Pitfalls of using Windows Task Manager

In the Software QA Techniques course I am teaching this semester I am including various aspects of performance measurement in the syllabus, since performance is one of the top three factors of database applications (the other two factors are performance, and its related factor, performance). No, those are not typos. Over my career at Sybase

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments