I'm looking for a part-time remote job.

Hire me


I'm the author of:

Mastering Redmine is a comprehensive guide with tips, tricks and best practices, and an easy-to-learn structure.

Check the book's project or

Buy the book

Social pages of the book:

By buying this book you also donate to Redmine (see this page).


Follow me:

Improvement #192

SQL optimization

Added by Andriy Lesyuk over 9 years ago. Updated over 8 years ago.

Status:
Open
Priority:
Major
Assignee:
Category:
Core
Target version:
Start date:
Due date:
% Done:

0%


Description

It should be researched how much SQL queries are done for a one request. There should be added some “profiler”... A code using SQL should be optimized to use minumal number of queries. Maybe also some “caching” should be added.


Related issues

Related to Orangutan - Improvement #918: Profiler/optimization Open 22 Sep 2010

History

#1 Updated by Andriy Lesyuk about 9 years ago

  • Priority changed from Minor to Major

#2 Updated by Andriy Lesyuk about 9 years ago

  • Target version set to 1.04

#3 Updated by Andriy Lesyuk about 9 years ago

  • Target version changed from 1.04 to 1.05

#4 Updated by Andriy Lesyuk about 9 years ago

  • Category set to Core

#5 Updated by Andriy Lesyuk almost 9 years ago

  • Target version changed from 1.05 to 1.07

#6 Updated by Andriy Lesyuk over 8 years ago

Perl DBI allows to prepare SQL query with placeholders... The resulting variable can be reused. The document claims it will speed up the application...

Also available in: Atom PDF

Terms of use | Privacy policy