Hi, Am 10.10.19 um 23:46 schrieb Brock Palen: > Looking to speed up my consolidations (the DB for one mac desktop client > takes a few hours and locks the tables CPU bound). you can try to add an index on JobTDate in the Job table. It helps a lot on MySQL and is in the queue to be included in the schema changes for the upcoming major release:
CREATE INDEX jobtdate_idx ON Job (JobTDate); ANALYZE TABLE Job; > I found on the list some references in 2018. Was there any progress on that? > Progress has been made, but nothing that was is really usable has been produced yet. Best Regards, Andreas -- Andreas Rogge [email protected] Bareos GmbH & Co. KG Phone: +49 221-630693-86 http://www.bareos.com Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646 Komplementär: Bareos Verwaltungs-GmbH Geschäftsführer: S. Dühr, M. Außendorf, J. Steffens, Philipp Storz -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/45683ff2-006a-08b1-a13b-a5928246bcce%40bareos.com.
signature.asc
Description: OpenPGP digital signature
