[Koha-devel] Bug 3069

[Archives and Collections Society]

At 08:01 AM 2/18/2013 +0000, Marcel de Rooy wrote:
>You could use the cron job cleanup_database.. for that purpose.

Many thanks for the suggestion -- a script that was "unknown to me" until 
today. I like the idea of adding dates into the logic, and the fact that 
import_records cascades to import_biblios (and import_items and 
import_record_matches.) I'll try it on the sandbox later today or tomorrow.

Best regards -- Paul



>-----Oorspronkelijk bericht-----
>Van: koha-devel-bounces at lists.koha-community.org 
>[mailto:koha-devel-bounces at lists.koha-community.org] Namens Paul
>Verzonden: zaterdag 16 februari 2013 23:51
>Aan: Koha Devel
>Onderwerp: [Koha-devel] Bug 3069
>
>This bug refers to the Z39.50 "reservoir" which cannot be [easily] emptied.
>A quick look in MySQL shows that we have:
>mysql> SELECT COUNT(*) FROM import_records;
>+----------+
>| COUNT(*) |
>+----------+
>|   148357 |
>+----------+
>1 row in set (0.01 sec)
>
>and the exact same in import_biblios (none in either import_items or
>import_record_matches) -- this relates to 29,410 valid biblios in our 
>catalogue.
>
>mysql> SHOW TABLE STATUS LIKE 'import_records'; tells me that this table
>has a Data_length of 1040508672 or just over 1 Gbyte.
>
>Is there a downside to deleting this data? [TRUNCATE TABLE import_records;
>same for import_biblios] *Limited* testing in my sandbox has shown no
>downside or side effects.
>
>The upside is a measurable improvement in the search time from
>koha-admin/cgi-bin/koha/cataloguing/addbooks.pl, and speed/size
>improvements for backups.
>
>My cataloguers tell me that they never use the "reservoir" as it only
>corresponds to historical data from previous multi-Z39.50 server searches
>from which they already selected the "best fit" and thought that they had
>discarded the rest. As an aside, I'd be curious to know how other libraries
>use this data.
>
>Thanks and best regards,
>Paul
>
>_______________________________________________
>Koha-devel mailing list
>Koha-devel at lists.koha-community.org
>http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>website : http://www.koha-community.org/
>git : http://git.koha-community.org/
>bugs : http://bugs.koha-community.org/