Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries

2012-06-19 Thread Pavel Ivanov
Sent: Tuesday, June 19, 2012 11:25 AM > To: chris_how...@mcafee.com > Cc: General Discussion of SQLite Database > Subject: EXT :Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries > > Then it's definitely different database files or indeed some really > weird network disk caching. &

Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries

2012-06-19 Thread Black, Michael (IS)
Database Subject: EXT :Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries Then it's definitely different database files or indeed some really weird network disk caching. Pavel On Tue, Jun 19, 2012 at 12:19 PM, <chris_how...@mcafee.com> wrote: > Good question. I thought the same,

Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries

2012-06-19 Thread Black, Michael (IS)
ite Database Subject: EXT :Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries Then it's definitely different database files or indeed some really weird network disk caching. Pavel On Tue, Jun 19, 2012 at 12:19 PM, <chris_how...@mcafee.com> wrote: > Good question. I thought the same, the is

Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries

2012-06-19 Thread Pavel Ivanov
he entire OS. > > Cheers > Chris > > -Original Message- > From: Pavel Ivanov [mailto:paiva...@gmail.com] > Sent: Tuesday, June 19, 2012 12:17 PM > To: Howell, Chris > Cc: sqlite-users@sqlite.org > Subject: Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries > &

Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries

2012-06-19 Thread Pavel Ivanov
e Database > Subject: Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries > >> 4.      Try to select against any of these tables and 0 results are returned >> yet, the client db hasn't actually changed it's size. > > By default SQLite doesn't shrink database file size when deleting d

Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries

2012-06-19 Thread Black, Michael (IS)
] SQL Lite 2.8.6 Not deleting Enteries -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent: Tuesday, June 19, 2012 11:27 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQL Lite 2.8.6 No

Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries

2012-06-19 Thread Chris_Howell
-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent: Tuesday, June 19, 2012 11:27 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries > 4.      Try to sel

Re: [sqlite] SQL Lite 2.8.6 Not deleting Enteries

2012-06-19 Thread Pavel Ivanov
> 4.      Try to select against any of these tables and 0 results are returned > yet, the client db hasn't actually changed it's size. By default SQLite doesn't shrink database file size when deleting data, although it reuses this space later when you insert new data. If you want to shrink file