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 11 years ago. Updated over 10 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 11 years ago

  • Priority changed from Minor to Major

#2 Updated by Andriy Lesyuk about 11 years ago

  • Target version set to 1.04

#3 Updated by Andriy Lesyuk almost 11 years ago

  • Target version changed from 1.04 to 1.05

#4 Updated by Andriy Lesyuk almost 11 years ago

  • Category set to Core

#5 Updated by Andriy Lesyuk almost 11 years ago

  • Target version changed from 1.05 to 1.07

#6 Updated by Andriy Lesyuk over 10 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