Ticket #154 (closed defect: fixed)

Opened 10 months ago

Last modified 10 months ago

SQLite doesn't have the OPTIMIZE TABLE statement

Reported by: rickc Owned by:
Priority: major Milestone: 0.4
Component: Habari Core Software Version: SVN
Keywords: sqlite, mysql, spam Cc: rick

Description

Habari calls the MySQL OPTIMIZE TABLE statement after a mass delete of spam.SQLite doesn't have this statement, but it does have a VACUUM statement that defragments and shrinks the entire database. This patch should create a replacement.

Attachments

sqlite.connection.php.patch (9.1 kB) - added by rickc 10 months ago.
Update sql_t() to replace MySQL OPTIMIZE TABLE

Change History

Changed 10 months ago by rickc

Update sql_t() to replace MySQL OPTIMIZE TABLE

Changed 10 months ago by skippy

  • status changed from new to closed
  • resolution set to fixed

Thanks! Applied in r1337!

Note: See TracTickets for help on using tickets.