sqlite question

[Kevin Crist]

We have a couple of sqlite dbs that we use in cloverleaf and basically all it stores is a timestamp from MSH.7 and an order number which is about 15 digits. My knowledge of sql or databases is almost zero. Do i need to purge any of these or how to even do that? Will there be any performance issues if we dont?  We are not having any now but just being curious.

Thanks for any insight.

Topic

[Jim Kosloskey]

It is never a bad idea to clean up data storage whether DB or other data structures.

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 60 years IT – old fart.

[Paul Bishop]

We try to have a timestamp on the record and then have a script that runs nightly to purge records based on that  timestamp.  There is a vacuum command after the purge to recover lost space on the db.  The db files are backed up prior to this happening.

Paul Bishop
Carle Foundation Hospital
Urbana, IL

[Max Drown (Infor)]

Check out the SQLite link in my signature. There’s a section on db cleanup in that thread.

Edit: Here’s the link: https://usspvlclovertch2.infor.com/viewtopic.php?p=29721

-- Max Drown (Infor)

[Author]

Replies