#27 ✓resolved
Kieran P

Poor zoom index rebuild performance

Reported by Kieran P | July 30th, 2008 @ 04:59 PM | in 1.1

james writes:

Running a zoom index rebuild (see Troubleshooting topic at http://www.kete.net.nz) is slow on privacy branch.

zoom_update_and_test was refactored to accept private items and needs optimisation.

Comments and changes to this ticket

  • Kieran P

    Kieran P July 30th, 2008 @ 04:59 PM

    james writes:

    As of r1168, acts_as_zoom is running ZoomDb.find_by_host_and_database_name(..) once or twice each time an item saved (depending on whether public and/or private versions are present). This is also the case for every time during zoom_rebuild_item.

    One way to mitigate this performance issue may be to keep the ZoomDb instance in a class variable to avoid constant SQL SELECTs during saves and rebuilds.

  • James

    James July 30th, 2008 @ 05:15 PM

    • State changed from “new” to “open”
    • Milestone cleared.

    One way to mitigate this performance issue may be to keep the ZoomDb instance in a class variable to avoid constant SQL SELECTs during saves and rebuilds.

    This optimisation has been made but did not provide substantial performance improvements.

    This should be looked in the future.

  • James

    James August 20th, 2008 @ 10:30 AM

    • Assigned user changed from “James” to “Walter McGinnis”

    Walter, I believe you're working on this, so I'll pass the ticket.

  • Walter McGinnis

    Walter McGinnis August 26th, 2008 @ 10:27 AM

    • Milestone set to 1.1

    This has been refactored to use a backgroundrb worker and one zoom connection. It is generally faster, but still not blazing fast for over a 1000+ records.

    There are some issues with skipped records that need resolving before this ticket is closed.

    Cheers, Walter

  • Walter McGinnis

    Walter McGinnis August 27th, 2008 @ 10:47 AM

    • State changed from “open” to “resolved”

    Remaining issues should be taken care of at this point. We'll need to update some topics on kete.net.nz that point at the old technique, but other than that this work is done.

    Enjoy, Walter

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป

Kete was developed by Horowhenua Library Trust and Katipo Communications Ltd. to build a digital library of Horowhenua material.

People watching this ticket

Tags

Referenced by

Pages