Performance of scripture verse display

Bug #593013 reported by Bedlore
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
lyricue
Confirmed
Wishlist
ChrisDebenham

Bug Description

Performance of scripture display is quite slow, more so when accessing sword modules however still too slow IMHO from database as well. While I have no technical insight on the specifics performance tweaking I would like to request that this area receives attention at some point. Perhaps an entire chapter could be cache into memory so verses load instantly and then there is a short pause when changing chapters?

Revision history for this message
ChrisDebenham (chris-debenham) wrote : Re: [Bug 593013] [NEW] Performance of scripture verse display

How slow are you talking about?
ie. what sort of time delay is there.
Can you run the following command and send me the output?
# time diatheke -b KJV -k John 1:1

You may need to change "KJV" to something else if you don't have the
KJV sword module installed.

On 12 June 2010 21:31:21 UTC+10, Bedlore <email address hidden> wrote:
> Public bug reported:
>
> Performance of scripture display is quite slow, more so when accessing
> sword modules however still too slow IMHO from database as well.  While
> I have no technical insight on the specifics performance tweaking I
> would like to request that this area receives attention at some point.
> Perhaps an entire chapter could be cache into memory so verses load
> instantly and then there is a short pause when changing chapters?
>
> ** Affects: lyricue
>     Importance: Undecided
>         Status: New
>
>
> ** Tags: feature request
>
> --
> Performance of scripture verse display
> https://bugs.launchpad.net/bugs/593013
> You received this bug notification because you are subscribed to
> lyricue.
>
> Status in Lyricue Lyric Display System: New
>
> Bug description:
> Performance of scripture display is quite slow, more so when accessing sword modules however still too slow IMHO from database as well.  While I have no technical insight on the specifics performance tweaking I would like to request that this area receives attention at some point.  Perhaps an entire chapter could be cache into memory so verses load instantly and then there is a short pause when changing chapters?
>
>
>

Revision history for this message
Bedlore (brendan-dbinformatics) wrote :

bedlore@bedlore-oat:~$ time diatheke -b KJV -k John 1:1
John 1:1: In the beginning was the Word, and the Word was with God, and the Word was God.

(KJV)

real 0m0.480s
user 0m0.384s
sys 0m0.076s

That is a very different story to what happens in Lyricue, a manual click and count test indicates around 7 seconds when click the > next verse button using sword modules. If database is used that time comes down to about 1.5/2 seconds which is a lot better but still lagy.

Revision history for this message
Bedlore (brendan-dbinformatics) wrote :

Seems I am experiencing a few issues that others aren't. Starting to consider a full rebuild of my OS using a different distro.

Revision history for this message
ChrisDebenham (chris-debenham) wrote :

Clicking the ">" button to go to the next verse will be slower as we have to run diatheke a couple of times (so as to figure out what the next verse is, if we need to go to next chapter etc)
It is better to add the entire section you want to view to the playlist. ie enter "John 3:1-20" and then add to playlist

Changed in lyricue:
assignee: nobody → ChrisDebenham (chris-debenham)
importance: Undecided → Medium
status: New → Confirmed
Revision history for this message
Bedlore (brendan-dbinformatics) wrote :

I'll try and test this suggestion a bit later, but it sounds unsuitable for our situation as we do a lot of scripture reading on the fly in a discussion type atmosphere and most of the time we are only told where to start reading no stop.

Revision history for this message
ChrisDebenham (chris-debenham) wrote : Re: [Bug 593013] Re: Performance of scripture verse display

I'll look at caching the majority of the info so as to speed things up

On 18 June 2010 16:43, Bedlore <email address hidden> wrote:
> I'll try and test this suggestion a bit later, but it sounds unsuitable
> for our situation as we do a lot of scripture reading on the fly in a
> discussion type atmosphere and most of the time we are only told where
> to start reading no stop.
>
> --
> Performance of scripture verse display
> https://bugs.launchpad.net/bugs/593013
> You received this bug notification because you are a bug assignee.
>
> Status in Lyricue Lyric Display System: Confirmed
>
> Bug description:
> Performance of scripture display is quite slow, more so when accessing sword modules however still too slow IMHO from database as well.  While I have no technical insight on the specifics performance tweaking I would like to request that this area receives attention at some point.  Perhaps an entire chapter could be cache into memory so verses load instantly and then there is a short pause when changing chapters?
>
>
>

Revision history for this message
ChrisDebenham (chris-debenham) wrote :

Is this still an issue?

Changed in lyricue:
status: Confirmed → Incomplete
Revision history for this message
Matthias de Schepper (matthias-deschepper) wrote :

In our service slow bible reading on the fly is also an isue.
Indeed diatheke itself is not that fast. To speed things up we now installed everything on SSD so diatheke becomes faster. It is more usable now, but still caching would make more advance in speed than the transtition to SSD.

klap-in (klap-in)
tags: added: featurerequest
removed: feature request
Changed in lyricue:
status: Incomplete → Confirmed
importance: Medium → Wishlist
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.