Ticket #47 (closed defect: fixed)

Opened 2 years ago

Last modified 2 years ago

Loading time not satisfying with big books

Reported by: tklein Owned by: tklein
Priority: critical Milestone: 0.3
Component: System Keywords:
Cc:

Description

It takes a too long time to load a big book like Isaiah or Psalms. The bottle neck most likely is the rendering of the view.

Change History

Changed 2 years ago by tklein

  • status changed from new to accepted

Changed 2 years ago by tklein

  • milestone changed from 0.2 to 1.0

postponed

Changed 2 years ago by tklein

  • milestone changed from 1.0 to 0.3

Changed 2 years ago by tklein

(In [157]) * Optimizations for the verse model regarding the layout/grouping/order of the verses for the tag browser (see #97)

  • Added optimized query for verses, which will add annotation info. With this annotation info it can determined in the view, which additional informatoin has to be loaded from the DB and which not. This is a huge performance improvement (see #47). In this case the bottleneck were mainly the sql queries made. The number of required sql queries is now reduzed to a minimal number. The loading time can be reduced by up to 2/3 of the previous loading time.
  • Make additional sql queries in _verse_box.erb and _verse.erb dependent on existence of meta information

Changed 2 years ago by tklein

  • status changed from accepted to closed
  • resolution set to fixed

This is treated as "solved" for the time being. At the moment there don't seem to be any other improvements for the bible text loading.

Note: See TracTickets for help on using tickets.