[sqlite] Any speed advantage in a view

I am coding a program that uses SQLITE and I am wondering if there are any advantages (speed?) to using a preset view instead of hard coding the SELECT query into the source code? Is the view precompiled at all? Thanks Randall Fox

[sqlite] Rowid in VIEWs?

The short question: do (temporary) VIEW's have rowid's in SQLITE? A small description of the problem: I have a small database of values, where I would like users to be able to execute simple filters (as (Key,Value) pairs) to return a subset of the data. On occasion, the result is quite large, a

Re: [sqlite] .db file size is not changing

I am using sqlite for .Net dll for my programs. Do I have to change the dll if I change the sqlite from 2.8.0 to 2.8.15? --- Will Leshner <[EMAIL PROTECTED]> wrote: > Unnikrishnan Nair wrote: > > > I am using 2.8.0 > > You might want to give 2.8.15 a try because I do > think there was a VACUUM

Re: [sqlite] .db file size is not changing

Unnikrishnan Nair wrote: I am using 2.8.0 You might want to give 2.8.15 a try because I do think there was a VACUUM bug fixed recently.

Re: [sqlite] .db file size is not changing

I am using 2.8.0 --- Will Leshner <[EMAIL PROTECTED]> wrote: > Unnikrishnan Nair wrote: > > > Well, I deleted the rows, droped the index and did > a > > vacuum on the table and nothing happen. I still > have > > the file size as 198M. Is there anything else I am > > missing? > > I've run into th

Re: [sqlite] .db file size is not changing

Unnikrishnan Nair wrote: Well, I deleted the rows, droped the index and did a vacuum on the table and nothing happen. I still have the file size as 198M. Is there anything else I am missing? --- Unnikrishnan Nair <[EMAIL PROTECTED]> wrote: You can always do a dump and reimport the db. John LeSue

Re: [sqlite] .db file size is not changing

Unnikrishnan Nair wrote: Well, I deleted the rows, droped the index and did a vacuum on the table and nothing happen. I still have the file size as 198M. Is there anything else I am missing? I've run into this myself. It's as if VACUUM decideds, for some reason, it can't do its job and bails. But I

RE: [sqlite] .db file size is not changing

Well, I deleted the rows, droped the index and did a vacuum on the table and nothing happen. I still have the file size as 198M. Is there anything else I am missing? --- Unnikrishnan Nair <[EMAIL PROTECTED]> wrote: > Thanks all. > --- "Drew, Stephen" <[EMAIL PROTECTED]> wrote: > > > Unni, > > >

RE: [sqlite] .db file size is not changing

Thanks all. --- "Drew, Stephen" <[EMAIL PROTECTED]> wrote: > Unni, > > Try using the VACUUM command: > > http://sqlite.org/lang.html#vacuum > > Steve > > -Original Message- > From: Unnikrishnan Nair [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 17, 2004 3:57 PM > To: [EMAIL PROTE

Re: [sqlite] .db file size is not changing

Use VACUUM. tezo. - Original Message - From: "Unnikrishnan Nair" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 17, 2004 7:56 AM Subject: [sqlite] .db file size is not changing > Hi all, > > I have a sqlite database. I had thousands of rows in > it. I did a test

Re: [sqlite] .db file size is not changing

On Aug 17, 2004, at 7:56 AM, Unnikrishnan Nair wrote: How can I reduce the size or is it possible at all? Check out VACUUM in the documentation.

RE: [sqlite] .db file size is not changing

Unni, Try using the VACUUM command: http://sqlite.org/lang.html#vacuum Steve -Original Message- From: Unnikrishnan Nair [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 17, 2004 3:57 PM To: [EMAIL PROTECTED] Subject: [sqlite] .db file size is not changing Hi all, I have a sqlite datab

[sqlite] .db file size is not changing

Hi all, I have a sqlite database. I had thousands of rows in it. I did a test with the database and everything was good. So before I ship it to production, I went to the database and I did drop all the index and 'deleted' all the rows from the table. I thought the size of the database will come do

[sqlite] Sqlite on Symbian OS

Hi, I search information on Symbian OS port of Sqlite : Is available ? Documentation exist ? Many thanks. Jean

RE: [sqlite] How to start?

Hi Cai, I think you will get a good document in the sqlite.org site. Best Regards, Bibin Bhanu Working hard makes me Luckier. -Original Message- From: cai yuan [mailto:[EMAIL PROTECTED] Sent: Tue 8/17/2004 2:37 PM To: [EMAIL PROTECTED] Subject: [sqlite] How to start? Hi, Is there

[sqlite] How to start?

Hi, Is there any existing sample code/doc I can follow for a quick start to use SQLite? Many thanks. Cai Yuan