Re: [sqlite] Optimizations to recover early from D state of the process

On 19 Oct 2016, at 2:22pm, Rutuja Shah wrote: > I observed that the process goes into D state and takes > around 5 to 15 minutes to recover. There is nothing in SQLite that could put a process in TASK_UNINTERRUPTIBLE mode. SQLite doesn't know much about your storage

Re: [sqlite] Optimizations to recover early from D state of the process

Rutuja Shah wrote: > the process goes into D state and takes around 5 to 15 minutes to recover. There appears to be something wrong with your storage system. Are you using a local disk, without RAID, not in a VM? Regards, Clemens ___ sqlite-users

[sqlite] Optimizations to recover early from D state of the process

Hi, Requirement 1: Data dumped to the DB every 15 minutes. One table per day, data is stored for the last 7 days. 2 such tables needed. Total number of tables - 7 days * 2 tables = 14 Average number of rows inserted per transaction (per 15 minutes per table) - 1,20,000 Requirement 2: Data dumped