Re: [sqlite] Parallel sqlite3

-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

Re: [sqlite] Parallel sqlite3

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] create one index on multiple columns or create multiple indexes, each of which is on one column?

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

[sqlite] Parallel sqlite3

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

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

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

Re: [sqlite] 3.7.0 foreign_keys and recursive_triggers default status

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 wrote: > > As of 3.6.23.1 the pragmas

[sqlite] 3.7.0 foreign_keys and recursive_triggers default status

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] Database corruption on Linux ext3

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

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

On Fri, Jul 16, 2010 at 5:14 PM, Jim Wilcoxson 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

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

On Fri, Jul 16, 2010 at 4:52 PM, Jay A. Kreibich 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