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

1576

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

1576

4:20 am, January 18, 2022

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

View Statistics

This Week

228

This Month

829

This Year

9

No Items Found.

Add Comment

Other Items in sqlite

load a random item from sqlite table SQLite - load a game from games, that has not been processed - AI 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 server 1

sqlite delete older sqlite records 13

sqlite SQLite database 2

sqlite Really 2

sqlite latest 3

sqlite result 4

sqlite Sqlite 17

sqlite Function 24

sqlite sqlite database 2

sqlite Record 16

sqlite select 4

sqlite Questions 7

sqlite record 15

sqlite limit 13

sqlite function 22

sqlite SQLite 23

sqlite sqlite 33

sqlite https 14

sqlite Server 5

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...