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
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)
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
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
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
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
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
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
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
-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
10 matches
Mail list logo