Did you see any improvement if application runs with high priority(nice)?
(CPU and I/O)
On Thu, Apr 3, 2014 at 12:56 AM, Kevin Xu wrote:
> The app seems to use between 60-80% CPU while it is running (from Activity
> Monitor) while disk use (using sudo iotop -P on OSX) seem
Kevin Xu wrote:
> The SQLite page_size is on its default setting (1024b), while I have
> not dug out the details on my specific SSD, a cursory Google search
> reveals SSDs report a 512b sector size for compatibility reasons while
> internally implementing a different native sector size (which is
>
On Thu, Apr 3, 2014 at 4:10 AM, Kevin Xu wrote:
> I have put up my insertion code here: http://pastebin.com/yjRW2mh3
As mentioned by Stephan Beal, use SQLITE_STATIC instead of
SQLITE_TRANSIENT for your text/blob binding.
As long as the memory buffer you are binding stays
On 3 Apr 2014, at 3:29am, Kevin Xu wrote:
> I have not discovered how to find internal memory throughput usage in OSX,
> and I agree that something is not allowing the system from maxing out the CPU
> or I/O.
A single application can max a single core of a single CPU if
I am posting my C repro for the virtual table join issue inline, below:
/*
* This repro is intended to demonstrate a possible bug when joining
* two virtual table instances together: only a subset of the expected
* rows is returned by sqlite. As far as we can tell, it only happens
* when the
I depend on the sqlite-announce list to get updates on new releases.
But it seems they haven't been posting there for the last couple releases.
Why not?
The archive shows the last announcement came for the 3.8.3.1 release.
___
sqlite-users mailing
Trouble ticket for this problem here:
http://www.sqlite.org/src/info/98825a79ce145686392d8074032ae54863aa21a3
On Thu, Apr 3, 2014 at 9:24 AM, Hinrichsen, John wrote:
> I am posting my C repro for the virtual table join issue inline, below:
>
> /*
> * This repro is
Neither of these are your problem, but I noticed the following in your
posted code:
PRAGMA auto_vacuum=NONE; has no affect after your tables are created.
You should move this setting earlier in your code.
http://www.sqlite.org/pragma.html#pragma_auto_vacuum
PRAGMA count_changes=OFF is
Patrick asked
"Where did the release announcements go?
This is the right place to go. Here you find announcements of new versions,
planned updates and bug-fixes even before they arrive at
Recent SQLite News
Recent SQLite News
Small. Fast. Reliable. Choose any three. About Sitemap
I¹m having problems to return results from a FTS4 table using ICU.
I¹m doing the usual routine to load an ICU collation:
1) Directly after opening the DB:
SELECT icu_load_collation('de_DE', 'LOCALIZED');
2) Creating some table
CREATE VIRTUAL TABLE ¹sometable' USING fts4 (tokenize='icu'
On 03/04/14 19:10, D. Richard Hipp wrote:
> SQLite version 3.8.4.3 is now available for download on the SQLite website:
The autoconf version is not linked and missing.
http://www.sqlite.org/download.html
http://www.sqlite.org/2014/sqlite-autoconf-3080403.tar.gz
Is this intentional?
Andreas
On Thu, Apr 3, 2014 at 2:25 PM, Andreas Stieger wrote:
> On 03/04/14 19:10, D. Richard Hipp wrote:
> > SQLite version 3.8.4.3 is now available for download on the SQLite
> website:
>
> The autoconf version is not linked and missing.
> http://www.sqlite.org/download.html
>
Documentation of the parameters to the collation callback could be improved:
(http://www.sqlite.org/c3ref/create_collation.html)
(1) A function prototype for the callback with named parameters is not given,
so one has to guess what the parameters are used for.
(2) It’s also not
On 4/3/2014 4:23 PM, Roman Fleysher wrote:
Is ability to insert multiple rows in one go a feature of a newer versions:
INSERT INTO myTable (designation) VALUES ('LoResFA_only'), ('HiResFA_only');
Support for this syntax was introduced relatively recently. I don't
remember which version
On Thu, Apr 3, 2014 at 4:48 PM, Igor Tandetnik wrote:
> On 4/3/2014 4:23 PM, Roman Fleysher wrote:
>
>> Is ability to insert multiple rows in one go a feature of a newer
>> versions:
>>
>> INSERT INTO myTable (designation) VALUES ('LoResFA_only'),
>> ('HiResFA_only');
>>
>
>
OK, thank you, Igor! I presume there is no way to get documentation for older
versions -- no point in keeping.
Roman
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Igor Tandetnik [i...@tandetnik.org]
Sent:
On Thu, Apr 3, 2014 at 4:52 PM, Roman Fleysher <
roman.fleys...@einstein.yu.edu> wrote:
> OK, thank you, Igor! I presume there is no way to get documentation for
> older versions -- no point in keeping.
>
The source code to the historical documentation is online:
> Wouldn't it be easier just to upgrade to SQLite 3.8.4.3? Why do you feel
> like you need to stick with 3.7.2 which is 3.5 years old (what is that in
> internet years? 100?)
I can't speak for Roman, but the biggest thing that keeps me from using newer
sqlite features is that I write desktop
Thank you for the links, Richard!
I am part of the Einstein Aging Study. The software (in internet years) should
be as old as the people we study (in calendar years).
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of
That was a fast turn-around. Thank you for addressing this issue so
quickly!
--
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee, you should not
disseminate, distribute, alter or copy this e-mail. Please notify
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 03/04/14 14:37, David King wrote:
> ... because of the author's opinions of the standard Python ways to
> require packages
As said author, the problem is that pip etc authors chose to make it
impossible to provide arguments to parts of the install
>
> This is the right place to go. Here you find announcements of new
> versions, planned updates and bug-fixes even before they arrive at
>
> Recent SQLite News
No, I think they're all supposed to show up in sqlite-announce; not
sqlite-users.
3.8.4.3 was announced in sqlite-announce. Very
Dear SQLiters,
Could some help if this is bad design or my lack of knowledge of SQL:
I have a table that keeps track of bad metrics from exams:
badMetric(examID, metric, reason)
I want to filter-out bad ones and keep only good ones from the user request:
request(examID, metric).
I thought:
On Thu, Apr 3, 2014 at 6:32 PM, Roman Fleysher <
roman.fleys...@einstein.yu.edu> wrote:
> Dear SQLiters,
>
> Could some help if this is bad design or my lack of knowledge of SQL:
>
> I have a table that keeps track of bad metrics from exams:
>
> badMetric(examID, metric, reason)
>
> I want to
Thread necromancy!
Back in 2007 I expressed a desire to efficiently insert a *list* of
values all at once, where the entire list is contained within a single
Tcl variable. The notation would be to use the variable name, prefixed
with $ or :, in place of the value list, intentionally omitting
Life is beautiful ! when you know what you are doing...
Thank you, Richard.
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Richard Hipp [d...@sqlite.org]
Sent: Thursday, April 03, 2014 6:39 PM
To: General Discussion
I have a table named aa like this:
id pid namenotetablename
1 0 s12 bbc k1
2 1 sss vac k2
another table named k1:
id pid namenote
11 1 f2 aaa
12 1 fs bbc
another table named k2:
id
On 4/3/2014 8:46 PM, YAN HONG YE wrote:
I have a table named aa like this:
id pid namenotetablename
1 0 s12 bbc k1
2 1 sss vac k2
another table named k1:
id pid namenote
11 1 f2 aaa
12 1 fs
On 4/3/2014 10:10 PM, Keith Medcalf wrote:
select *
from k1
union
select *
from k2;
My understanding of the question was, how to select from tables whose
names are somehow computed or extracted from another table
--
Andy Goth |
___
Hello,
yep; else; it would require an "eval" or the support to sql scripting, as
none of this exists, it has to be done at the program level; in a regular
two queries run, nothing fancy or extraordinary.
Best.
On Thu, Apr 3, 2014 at 9:13 PM, Andy Goth wrote:
> On
refactoring the model using views might be an option too.
On Thu, Apr 3, 2014 at 9:50 PM, mm.w <0xcafef...@gmail.com> wrote:
> Hello,
>
> yep; else; it would require an "eval" or the support to sql scripting, as
> none of this exists, it has to be done at the program level; in a regular
> two
On 2014-04-03, 7:19 PM, Andy Goth wrote:
I don't believe this can be done in pure SQL since table names are not
values. That doesn't mean it can't be done, though you will have to put
some of the logic in your program itself.
I expect that in the future this limitation will no longer exist.
32 matches
Mail list logo