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

lua-l archive

[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: Thu, 30 Jan 2014 01:42:22 +0100

On Wed, 29 Jan 2014 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