Re: [sqlite] why does gperftools shows sqlite3_memory_used as using the largest amount of memory

Mayank Kumar (mayankum) wrote: > -my application sqlite based runs for months before it might get restarted > -while its running there are places we need to execute the following series :- > - sqlite3_bind_int64(deleteStmt > - sqlite3_step(deleteStmt) > -

[sqlite] Putting the journal/WAL on a separate filesystem

Motivation: We have many thousands of sqlite databases. Our incremental block store backups cost a lot of money. Judging from the disk access patterns on our machines, I strongly suspect that sqlite is writing a lot of things which are temporary, but amount to bytes-on-blockstore that we pay for

[sqlite] Vdbe Program Generation

Can you please tell me which function is sqlite actually generates the Vdbe program for a give sql string ? Thanks Prakash ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Memory Usage

Hi, I was wondering what options I can tune to make sqlite use more memory. We are currently using the memsys5 allocator and giving it a 2G buffer, but it doesn't seem to be using any more than 32MB. Thanks, Dave M ___ sqlite-users mailing list

Re: [sqlite] Vdbe Program Generation

On Fri, 3 Oct 2014 18:39:29 +0530, Prakash Premkumar wrote: > Can you please tell me which function is > sqlite actually generates the Vdbe > program for a give sql string ? http://www.sqlite.org/c3ref/prepare.html -- Groet, Kees Nuyt

Re: [sqlite] Putting the journal/WAL on a separate filesystem

The WAL and journal files must (normally) be in the same directory as the database in order that following a power-loss or system crash, the new process to open the database file will be able to find the WAL or journal and perform recovery. If you are running in a very specialized environment,

[sqlite] passing error messages to pysqlite

I have a sqlite3 database. In the networkied are I have the db is locked (wee've discussed this before, and I'm using it mostly on a local machine, but I need to test certain conditions, networking being one). In the sqlite3 command line, when I try to insert new info I get a dabase locked

Re: [sqlite] passing error messages to pysqlite

Are you committing the change? >-Original Message- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Mark Halegua >Sent: Friday, 3 October, 2014 20:58 >To: sqlite-users@sqlite.org >Subject: [sqlite] passing error messages to pysqlite > >I have

Re: [sqlite] passing error messages to pysqlite

Ah, ok. after doing a database commit I get the error going to stderr. Now it's just a matter of capturing/redirecting the stderr output and using an except there. Thanks. Mark On Friday, October 03, 2014 11:35:08 PM you wrote: > the sqlite3 command line doesn't require a commit, it

Re: [sqlite] passing error messages to pysqlite

Yes. pysqlite/sqlite3 in python tries to manage transactions for you by automatically starting them, and you need to commit them yourself. This is controlled by the isolation_level attribute set on the connection (can also be set as a parameter when you open the connection). The default