Re: [sqlite] How much a table takes (will this query always work)

2010-07-17 Thread Max Vlasov
On Fri, Jul 16, 2010 at 4:52 PM, Jay A. Kreibich j...@kreibi.ch wrote: Check out sqlite3_analyzer. This is available in binary format only on the SQLite website. http://sqlite.org/download.html Thanks, the tool is really great, but just wondering can the code used there be part of

Re: [sqlite] How much a table takes (will this query always work)

2010-07-17 Thread Max Vlasov
On Fri, Jul 16, 2010 at 5:14 PM, Jim Wilcoxson pri...@gmail.com wrote: You mean, like this? pragma page_count pragma page_size size = page_count*page_size Doh. Nevermind. I see you said table, not database. :) If I'm asked, the syntax PRAGMA page_count(table_name/index_name)

Re: [sqlite] Database corruption on Linux ext3

2010-07-17 Thread Chris Wedgwood
On Thu, Jul 15, 2010 at 10:20:22PM +0200, Florian Weimer wrote: It's a generic Linux problem, not an ext3-specific issue. Until recently, the Linux block layer had no concept of a sync operation. Linux basically assumed that all writes were synchronous and ordered, which they are not if your

[sqlite] 3.7.0 foreign_keys and recursive_triggers default status

2010-07-17 Thread Ben Danper
As of 3.6.23.1 the pragmas foreign_keys and recursive_triggers default to OFF, but the documentation mentions they might get enabled in the future. It would seem natural for these features to be enabled by default; as I understand the only reason they are disabled is to avoid affecting

Re: [sqlite] 3.7.0 foreign_keys and recursive_triggers default status

2010-07-17 Thread Pavel Ivanov
Looks like the answer to your question is negative: http://www.sqlite.org/draft/pragma.html#pragma_foreign_keys http://www.sqlite.org/draft/pragma.html#pragma_recursive_triggers Pavel On Sat, Jul 17, 2010 at 7:27 PM, Ben Danper seb...@live.com wrote: As of 3.6.23.1 the pragmas foreign_keys

[sqlite] create one index on multiple columns or create multiple indexes, each of which is on one column?

2010-07-17 Thread Peng Yu
This question may be trivial. But I'm wondering, whether I should create one index on multiple columns or create multiple indexes, each of which is on a single column. The condition of the 'select' statement can be a logic operation on any of the column of the table and their combinations. I

[sqlite] Parallel sqlite3

2010-07-17 Thread Peng Yu
Hi, I import a tab-sep file and create index on it. It seems that sqlite3 only use 1 CPU. Is there a way to make it use more than one CPUs? I searched 'parallel' on sqlite.org. But I don't find anything. -- Regards, Peng ___ sqlite-users mailing list

Re: [sqlite] create one index on multiple columns or create multiple indexes, each of which is on one column?

2010-07-17 Thread Simon Slavin
On 18 Jul 2010, at 5:46am, Peng Yu wrote: This question may be trivial. But I'm wondering, whether I should create one index on multiple columns or create multiple indexes, each of which is on a single column. The condition of the 'select' statement can be a logic operation on any of the

Re: [sqlite] Parallel sqlite3

2010-07-17 Thread Simon Slavin
On 18 Jul 2010, at 5:51am, Peng Yu wrote: I import a tab-sep file and create index on it. It seems that sqlite3 only use 1 CPU. Is there a way to make it use more than one CPUs? I searched 'parallel' on sqlite.org. But I don't find anything. This operation is not slowed down by your CPU

Re: [sqlite] Parallel sqlite3

2010-07-17 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/17/2010 09:51 PM, Peng Yu wrote: I import a tab-sep file and create index on it. It seems that sqlite3 only use 1 CPU. Is there a way to make it use more than one CPUs? What kind of speeds are you seeing, and what do you think you would see