search

Othernet-Project / librarian-core

GNU General Public License v3.0
1 stars 0 forks source link

Persist datetime values as integers #2

Closed foxbunny closed 8 years ago

foxbunny commented 8 years ago

Based on cursory testing for the database (pun intentional) from Librarian v0.4, it is determined that the database column containing timestamps as TEXT value poses a considerable performance hit when usde in queries like ORDER BY. Consider switching to storage in INTEGER format using seconds from Unix epoch.

n0phx commented 8 years ago

Solved in fc3eed60ccfc324170de6d13c9729dd2145bd0d1