[SEO-Updates] Paid Bills Database Maintenance

JMiley at library.ohio.gov JMiley at library.ohio.gov
Wed Apr 5 13:29:12 EDT 2023


[Text  Description automatically generated with medium confidence]

Greetings -

Over the past few months, bill reports have been taking significant time to run which in turn causes a bottleneck when running reports. Upon investigating the matter, it was determined that a large amount of historical paid bills in the database is causing the performance issue. The SEO Team has made the decision to remove paid bills from the database that have been paid for over 5 years.

It is important to note that this database maintenance task will not remove any outstanding bills. We will be removing the historical paid bills beginning Sunday, April 16.

Cheers,

[cid:image002.png at 01D96307.3F3D8EA0]
Jay Miley
Customer Service & Library System Manager

State Library of Ohio
SEO Service Center
40780 Marietta Rd.
P.O. Box 185
Caldwell, OH 43724

Phone: 1-877-552-4262 x202
Email: jmiley at library.ohio.gov<mailto:jmiley at library.ohio.gov>

[cid:image003.png at 01D96307.3F3D8EA0]<https://outlook.office365.com/owa/calendar/SEOConsortium@ohiodas.onmicrosoft.com/bookings/>


https://servingeveryohioan.org/





-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.oplin.org/pipermail/seo-updates/attachments/20230405/0d80d304/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 13231 bytes
Desc: image001.jpg
URL: <http://lists.oplin.org/pipermail/seo-updates/attachments/20230405/0d80d304/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 127344 bytes
Desc: image002.png
URL: <http://lists.oplin.org/pipermail/seo-updates/attachments/20230405/0d80d304/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 12195 bytes
Desc: image003.png
URL: <http://lists.oplin.org/pipermail/seo-updates/attachments/20230405/0d80d304/attachment-0001.png>


More information about the SEO-Updates mailing list