Re: [SQLite] Use of db:exec cause 5 second delay

[Date Prev][Date Next][Thread Prev][Thread Next] [Date Index] [Thread Index]

• Subject: Re: [SQLite] Use of db:exec cause 5 second delay
• From: Gilles Ganault <gilles.ganault@...>
• Date: 2014年1月30日 01:42:22 +0100

---

On 2014年1月29日 19:07:24 -0500, Nathan Angelacos
<nangel@nothome.org> wrote:
>try using tmps (from your post, /run/shm would work) and see if it 
>improves. If it does, then you know its the SD card:
>
>local db = sqlite3.open('/run/shm/test.db')
Yes, it runs in a fraction of a second. I'll read up on SD and ext4.
Thanks for the tip.

---

• Follow-Ups:
  • Re: [SQLite] Use of db:exec cause 5 second delay, David Favro

• References:
  • [SQLite] Use of db:exec cause 5 second delay, Gilles Ganault
  • Re: [SQLite] Use of db:exec cause 5 second delay, David Favro
  • Re: [SQLite] Use of db:exec cause 5 second delay, D. Matt Placek
  • Re: [SQLite] Use of db:exec cause 5 second delay, Gilles Ganault
  • Re: [SQLite] Use of db:exec cause 5 second delay, Nathan Angelacos

• Prev by Date: Re: [SQLite] Use of db:exec cause 5 second delay
• Next by Date: Re: [SQLite] Use of db:exec cause 5 second delay
• Previous by thread: Re: [SQLite] Use of db:exec cause 5 second delay
• Next by thread: Re: [SQLite] Use of db:exec cause 5 second delay
• Index(es):
  • Date
  • Thread