search

shannah / xataface

Framework for building data-driven web applications in PHP and MySQL
http://xataface.com
GNU General Public License v2.0
134 stars 57 forks source link

Safe to empty dataface__record_mtimes? #122

Closed mike-at-acs closed 3 years ago

mike-at-acs commented 3 years ago

Our dataface__record_mtimes table has grown to over 2.8 million lines on our site (in constant use).
Is it safe to completely empty that table via phpmyadmin or will that cause functionality issues for our users? Is the usage of that table documented somewhere? Thanks in advance.

shannah commented 3 years ago

This records modification times of individual records. If you are using certain caching features, then it may use this table to determine if the cache should be invalidated. It should be safe to delete this table, but I suggest not deleting it, as this information may be helpful to the app.

mike-at-acs commented 3 years ago

OK. Will leave it as is for now. Thanks for the quick turnaround!