Conversation

Notices

1. Embed this notice
   Alex Gleason (alex@gleasonator.com)'s status on Thursday, 11-Apr-2024 03:53:02 JST Alex Gleason
   I'm having a problem with 10 minute long SQLite queries after rebooting the operating system, but then it gets fast after everything is loaded the first time. Rebooting the application is also fine, just not the OS.
   • Embed this notice
     Curtis Rock, SkD (curtis@social.teci.world)'s status on Thursday, 11-Apr-2024 05:34:42 JST Curtis Rock, SkD

     in reply to

     @alex https://sqlite-users.sqlite.narkive.com/rUeC9GQR/slow-query-after-reboot

     To speedup the initial access, you can:

     • read the entire file once before you start your query
     • run the following query (once) select count(last_column) from big_table; this will touch each record in a kind of optimal order
     Alex Gleason likes this.
   • Embed this notice
     Alex Gleason (alex@gleasonator.com)'s status on Thursday, 11-Apr-2024 05:34:47 JST Alex Gleason

     in reply to

     • Curtis Rock, SkD
     @curtis Excellent find. 18 years ago!