Re: [sqlite] Vacuum command fails

Slavin wrote: On 17 Jul 2014, at 10:03pm, veeresh kumar wrote: > I did google aswell :-)...I did set PRAGMA temp_store = 1 (PRAGMA temp_store > = FILE). But it did not help. I get SQLITE_NOMEM error message. What version of SQLite are you using ?  The simplest way is probably to tell u

Re: [sqlite] Vacuum command fails

d the command was successful. If my above understanding is correct, i guess we need to update help document.  Thank you -Veeresh On Thursday, 17 July 2014 10:30 AM, Simon Slavin wrote: On 17 Jul 2014, at 6:24pm, veeresh kumar wrote: > I tried to execute Vacuum on the sqlite database of s

Re: [sqlite] Vacuum command fails

memory. On Thursday, 17 July 2014 12:11 PM, Roger Binns wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 17/07/14 10:42, veeresh kumar wrote: > When i execute the command PRAGMA temp_store, it returned me 0. What is > the ideal value that needs to be set? A quick google search

Re: [sqlite] Vacuum command fails

When i execute the command PRAGMA temp_store, it returned me 0. What is the ideal value that needs to be set? On Thursday, 17 July 2014 10:30 AM, Simon Slavin wrote: On 17 Jul 2014, at 6:24pm, veeresh kumar wrote: > I tried to execute Vacuum on the sqlite database of size 14GB and

[sqlite] Vacuum command fails

I tried to execute Vacuum on the sqlite database of size 14GB and it failed with an error "out of memory". I was under the impression that it copies the database file and then performs vacuum on that file. Here it looks like its using RAM. Appreciate your inputs from the experts. ___

[sqlite] Acceptable growth of WAL file size?

I saw below thing listed as disadvantage in http://www.sqlite.org/wal.html#ckpt . “WAL works best with smaller transactions. WAL does not work well for very large transactions. For transactions larger than about 100 megabytes, traditional rollback journal modes will likely be faster. For tran

Re: [sqlite] Reader locks writer in truncate mode?

commit the data? On Thursday, 13 March 2014 4:43 PM, Simon Slavin wrote: On 13 Mar 2014, at 11:12pm, veeresh kumar wrote: > Thanks a lot for the response. Is there any way to identify which > thread/process is actually blocking the reader thread or vise versa? Only in that it

Re: [sqlite] Reader locks writer in truncate mode?

, 2014 2:30 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Reader locks writer in truncate mode?     On 13 Mar 2014, at 9:27pm, Igor Tandetnik wrote:   > On 3/13/2014 5:24 PM, veeresh kumar wrote: >> In a multi-threaded application, say a reader thread has read 100 records

[sqlite] Reader locks writer in truncate mode?

In a multi-threaded application, say a reader thread has read 100 records from the table and reading is still in progress before which writer thread writes data and tries to commit. Its causing database lock.Is this expected? Note : journal_mode is set as truncate _

[sqlite] Manual call to sqlite3_wal_checkpoint

I have turned off using PRAGMA wal_autocheckpoint = 0. There is a background thread which would call sqlite3_wal_checkpoint at some interval of time to ensue that WAL size does not grow big. I dont see any error returned by API sqlite3_wal_checkpoint. Also I dont see WAL size being reduced afte

Re: [sqlite] Time taken to perform checkpoint operation and does it lock database during this operation?

are being followed for Multi threaded application. Thank you, -Veeresh On Thursday, 20 February 2014 4:46 PM, Richard Hipp wrote: On Thu, Feb 20, 2014 at 7:41 PM, veeresh kumar wrote: Haven't measured the time, but I have seen a pause before commit happens. As stated duri

Re: [sqlite] Time taken to perform checkpoint operation and does it lock database during this operation?

ary 2014 4:21 PM, Richard Hipp wrote: On Thu, Feb 20, 2014 at 7:08 PM, veeresh kumar wrote: Hi, > I am using "PRAGMA >journal_mode=WAL;" with "PRAGMA synchronous=NORMAL;",with >default auto check point and page size = 1024 bytes.  Since checkpoint >occurs aut

[sqlite] Time taken to perform checkpoint operation and does it lock database during this operation?

Hi,  I am using "PRAGMA journal_mode=WAL;" with "PRAGMA synchronous=NORMAL;",with default auto check point and page size = 1024 bytes.  Since checkpoint occurs automatically after every 1 MB, how much time it checkpoint operation would take to complete as the database size grows large (range 1GB - 

Re: [sqlite] wal_autocheckpoint

, 2014 10:01 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] wal_autocheckpoint   On 02/01/2014 12:13 AM, veeresh kumar wrote: > Hi All, >   > Below is my Sqlite settings. The current database size is  ~ 8GB >   > PRAGMA journal_mode = WAL > PRAGMA synchronous

[sqlite] wal_autocheckpoint

Hi All,   Below is my Sqlite settings. The current database size is  ~ 8GB   PRAGMA journal_mode = WAL PRAGMA synchronous = NORMAL PRAGMA wal_autocheckpoint = 50"   With the above check point, the time taken to commit transaction to actual database file after reaching a checkpoint is 2.5 to 3

[sqlite] Performance based on Sqlite Configuration

I am finding it hard which is the best configuration for most of the large scale application. Our database size grows from 0 – 45 GB . As the database size grows, performance seems to be degrading. Performance of the same application is better when it compared to Sql Server. I am in the middle of

[sqlite] performance difference based on the sqlite configuration?

I do have a similar issue. I am finding it hard which is the best configuration for most of the large scale application. Our database size grows from 0 – 45 GB . As the database size grows, performance seems to be degrading.   Major operations include insertion/read/delete   Current settings:   PRA

[sqlite] Is there

Hi, I want to detect if a sqlite database is already connected to an application?  Is there anyway sqlite API available for this? I have a use case where 2 different applications would try to connect to same database and I want to detect that and give info to the user. Thank you -Veeresh ___

[sqlite] REINDEX - Performance increase?

We are looking for database maintenance commands for the Sqlite database and came across 2 commands which we felt that it would improve the performance if used. The commands are VACUUM and REINDEX. I came to know that VACUUM just helps us to reclaim the space and does not give any performance in

Re: [sqlite] Vacuum command in a transaction?

Thanks Igor and Simon for your inputs. I was under the impression that VACUUM would also help performance since it does defragmentation. On Tuesday, 10 December 2013 3:02 PM, Simon Slavin wrote: On 10 Dec 2013, at 8:04pm, veeresh kumar wrote: > -If we put inside a transact

[sqlite] Vacuum command in a transaction?

The database size that we use in the application can grow upto 50 GB. We have an option of shrinking the database using the Vacuum command. I understand that Vacuum command consumes lots of time to execute,but i dont see any other way. I wanted to know what is the good way to execute Vacuum com

[sqlite] count (*) performance

Hi , I see that in release history for 3.8.1 below item. "Estimate the sizes of table and index rows and use the smallest applicable B-Tree for full scans and "count(*)" operations." Does it mean that performance of count(*) has been improved in 3.8.1 and if yes by how much? We were using coun

[sqlite] Disable specific foreign key constraint sqlite3

Hi, Is there a way to disable/enable specific foreign key constraint in sqlite3? Below is the sqlserver query , would like to know similar query in sqlite 3 ALTER TABLE tablename WITH NOCHECK NOCHECK CONSTRAINT FK_Column Thank you -Veeresh ___ sqlite-

[sqlite] Convert Sqlserver script to Sqlite script

Hi,  Is there any tool which would convert a sql server script to sqlite script? Thank you ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users