Drupal Performance Tip – “I’m too young to die” – know your DB engines


Liran is 31 years old and married to his beloved soul-mate Tal. As an avid supporter of the open source community, he plays the role of leading developer for some projects and contributing code to many others. Some of his geek activities include programming, playing his guitar and even running The Hacker’s Choice BBS back in the pre-Internet days of ’95. Liran is passionate about creating software products, combining his technical skills with an exquisite entrepreneurial spirit and business orientation to build successful ventures. Liran currently works at HP Software, leading the development team on a Drupal based collaboration platform in HP's Live Network R&D group. At HPLN, Liran plays a key role in system architecture design, shaping the technology strategy from planning and development to deployment and maintenance in HP's IaaS cloud. Acting as the technological focal point, he loves mentoring team mates, drive for better code methodology and seek out innovative solutions to support business strategies.

You may also like...

2 Responses

  1. dawehner says:

    Good article, … you should always think before doing a count query.

    Just in general … I would recommend mostly always to use a light pager (which is included into Drupal 8 as mini pager), because it does not run the count query at all.

    In general though this approach doesn’t make sense for pagers, given that you need the amount of items in there.

  2. Jesse says:

    Info on your note. Views executes a COUNT query on the entire result set which is used to determine the “last” link. There are many different approaches to handling this throughout the webs

Leave a Reply to Jesse Cancel reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>