Re: [sqlite] Rule of thumb for estimating index size

On Fri, 21 Apr 2006, Rusty Conover wrote: Hi, Is there an easy way to get an estimate on the space used by an existing index? If not what is a good guess on how to estimate the size? My guess would be (assuming text fields are being indexed): [total length of all index keys] + [number of

Re: [sqlite] Getting free pages count

Alexey Belyaev wrote: Hi! In current versions sqlite (3.2.7 and later) not enought functions, for receive information abut free pages count (or used pages count). I have to use not official methods :( May I expect that this functions will be introduced in next versions sqlite? I too

Re: [sqlite] Rule of thumb for estimating index size

Hi Christian, thanks for the explanation, when you explain it like that it's so simple, the index in the book concept didnt even come to me. lol. John. On 21/04/06, Christian Smith [EMAIL PROTECTED] wrote: On Fri, 21 Apr 2006, Rusty Conover wrote: Hi, Is there an easy way to get an

Re: [sqlite] Getting free pages count

I mean freepages.c under not official methods :) -- View this message in context: http://www.nabble.com/Getting-free-pages-count-t1485769.html#a4025820 Sent from the SQLite forum at Nabble.com.

[sqlite] Use sqlite on solaris with java in multithreaded web application

Hi, I want to use sqlite as database in Solaris Environment in Java based web application. There can be multiple read only requests coming to database at same time. I tried using javasqlite driver for using sqlite with Java but as number of users or request increase response time increase

Re: [sqlite] Use sqlite on solaris with java in multithreaded web application

Hi, I want to use sqlite as database in Solaris Environment in Java based web application. There can be multiple read only requests coming to database at same time. I tried using javasqlite driver for using sqlite with Java but as number of users or request increase response time increase

RE: [sqlite] Use sqlite on solaris with java in multithreaded web application

Hi Jay, Thanks for your immediate reply. I will send you schema and query for which I feel there is problem. On the other hand the driver I used for connection between java and sqlite (javasqlite- http://www.ch-werner.de/javasqlite/) states that this driver is tested only in Linux. I was

Re: [sqlite] Use sqlite on solaris with java in multithreaded web application

I will send you schema and query for which I feel there is problem. On the other hand the driver I used for connection between java and sqlite (javasqlite- http://www.ch-werner.de/javasqlite/) states that this driver is tested only in Linux. I was wondering even if I should use SQLite with

Re: [sqlite] Re: SQL statements in progress error message

On 4/20/06, Igor Tandetnik [EMAIL PROTECTED] wrote: Nicholas Bastin [EMAIL PROTECTED] wrote: When trying to commit a transaction, I'm getting the following error message from sqlite3_exec(): cannot commit transaction - SQL statements in progress Is there any way to find out what

[sqlite] sqlite3_prepare with non-scalar variables?

Is there any way to effectively prepare the following statement: SELECT * FROM some_table WHERE id IN (?); where the contents of the variable are a vector? (1,3,5,9,34,57), etc. I've been building up these just using text and using exec, but it seems you'd want to have a

[sqlite] Re: sqlite3_prepare with non-scalar variables?

Nicholas Bastin [EMAIL PROTECTED] wrote: Is there any way to effectively prepare the following statement: SELECT * FROM some_table WHERE id IN (?); where the contents of the variable are a vector? (1,3,5,9,34,57), etc. I've been building up these just using text and using exec, but it seems

[sqlite] Reuse of TCL array causes memory leak

I've run into an issue where the reuse of a TCL array (to hold query results) causes a catastrophic memory leak. The eval command is called with the same array name again and again. Each successive query / array population exponentially consumes more and more memory (until the system crashes).

Re: [sqlite] Getting free pages count

Alexey Belyaev wrote: I mean freepages.c under not official methods :) I know. :) I'm hoping that someday it will be officially supported. If Dr. Hipp feels that it adds unnecessary bloat to the library, then maybe it can be supported but IFDEFd out by default, and those of us that want

Re: [sqlite] Rule of thumb for estimating index size

Rusty Conover [EMAIL PROTECTED] wrote: Hi, Is there an easy way to get an estimate on the space used by an existing index? If not what is a good guess on how to estimate the size? My guess would be (assuming text fields are being indexed): [total length of all index keys] +

Re: [sqlite] Reuse of TCL array causes memory leak

Aldobino Braga [EMAIL PROTECTED] wrote: I've run into an issue where the reuse of a TCL array (to hold query results) causes a catastrophic memory leak. The eval command is called with the same array name again and again. Each successive query / array population exponentially consumes more

[sqlite] Sqlite inside MySQL as one of the pluggable storage mechanisms ?

I had a musing while reading: http://news.com.com/2100-7344_3-6063599.html?part=rsstag=6063599subj=news where it reminded me of one of MySQL's features: MySQL's database is built so that it can use a range of different storage mechanisms, tuned for different purposes, such as