function to delete older sqlite records when the limit is reached [ sqlite ] - KruXoR

sqlite

function to delete older sqlite records when the limit is reached

Posted in sqlite

8622

4:20 am, January 18, 2022

function to delete older sqlite records when the limit is reached

I had an issue where a sqlite database was hitting over 100,000 records and this was causing quite a lot of lag and crashing on my server, the number of records was not really meant to be this high, so i can just keep a few thousand so it does not cause lag.

This is the function i added and run before or after the latest item is inserted to remove older items in the database.

PHP

// this will delete records over the specified number if run.
// it will keep the latest $records_to_keep number and delete older ones.
public function delete_over($records_to_keep = 1000) {
  $db_table_name = $this->db_table_name;
  $sql = "DELETE FROM $db_table_name WHERE ROWID IN (SELECT ROWID FROM $db_table_name ORDER BY ROWID DESC LIMIT -1 OFFSET $records_to_keep)";
  $result = $this->db->query($sql);
}

// example run on keywords class
$keywords->delete_over($records_to_keep = 1000);

Posted in sqlite

8622

4:20 am, January 18, 2022

External Link for function to delete older sqlite records when the limit is reached

View Statistics

This Week

148

This Month

715

This Year

2279

No Items Found.

Add Comment

Other Items in sqlite

mysql to sqlite notes function to delete older sqlite records when the limit is reached count total results from distinct sqlite

Related Search Terms

sqlite https 110

sqlite item 104

sqlite server 102

sqlite latest 101

sqlite select 97

sqlite Where 74

sqlite after 101

sqlite Using 78

sqlite stack 90

sqlite using 81

sqlite Function 89

sqlite this 114

sqlite test 101

sqlite sqlite 125

sqlite html 131

sqlite function 79

sqlite Record 102

sqlite Questions 104

sqlite database 101

sqlite Order 101

sqlite Really 110

sqlite Added 98

sqlite when 109

sqlite SQLite 120

sqlite record 109

sqlite limit 108

sqlite spec 120

sqlite really 99

sqlite Server 87

sqlite flow 129

sqlite order 116

sqlite added 96

sqlite Stack 124

sqlite where 98

sqlite overflow 122

sqlite questions 99

sqlite Latest 94

sqlite result 98

sqlite delete older sqlite records 97

Welcome

This is my test area for webdev. I keep a collection of code here, mostly for my reference. Also if i find a good link, i usually add it here and then forget about it. more...