[...]
Can you please run sqlite3_analyzer [...] on both
the original database and the database after VACUUM
and send me the output?
done, send 2 txt-files
greetings
Oliver
___
sqlite-users mailing list
sqlite-users@sqlite.org
Hello there,
I hope, someone can help me with the problem I'm having.
The whole picture:
I'm running a .NET 3.5 application using System.Data.SQLite as provider.
Inserting Data happens via Entity Framework and Linq to Entitites. For querying
data I use DataAdapter/DataView/DataGridView
Is Sqlite somewhere caching data? If so, how do I disable it or decrease the
amount of cached data?
http://www.sqlite.org/pragma.html#pragma_cache_size
Pavel
On Tue, Sep 21, 2010 at 1:24 PM, Richard Wähnelt deslo...@web.de wrote:
Hello there,
I hope, someone can help me with the problem
I've a table with 15 columns, including industry number, industry
description, and state. I'm trying to formulate the proper SELECT statement
to return the count of rows for each industry number/description in each of
the 5 states. I've looked at the aggregate function chapter in Rick van der
Rich Shepard rshep...@appl-ecosys.com wrote:
The closest I've come so far is:
sqlite select sic, sic_desc, state, count(*) from Companies group by sic;
The 'group by' phrase returns one row per group, which is what I want as
long as the group is a compound of industry number and state
Just
sqlite select sic, sic_desc, state, count(*) from Companies group by
sic;
The 'group by' phrase returns one row per group, which is what I want as
long as the group is a compound of industry number and state (the
description makes it easier to read and is fixed in association with
Hello List,
Apologies if this is the wrong list to post to. Can anyone tell me if an
overflow page is encapsulated within a B-Tree page or if it starts on a
standard page boundary and has its first 4 bytes as the next overflow page
number?
Thanks,Scott