Lightning Quick Reports in Polaris
After migrating to Polaris from Horizon Salt Lake County Library ran into a bit of a dilemma: we now had access to much more data, stored in the Transaction database, but accessing it could be cumbersome and slow the system down. Our solution was to create our own aggregate tables that, made staff-run reports take seconds rather than…well, a whole long time. Come find out what aggregates we created (including Dewey 10’s) and how to get started.
Colleen Medling - Salt Lake County Library System
cmedling@slcolibrary.org
Year_table_sql.txt (477 Bytes)
Month_table_sql.txt (483 Bytes)
Lightening_quick_reports_in_Polaris.pptx (57.7 KB)
Circulation_by_Patron_Code_Stored_Procedure.txt (2.0 KB)
CREATE_TABLE_PATRONCIRC_MONTH_YEAR.txt (725 Bytes)