On 19 Sep 2018, at 8:47pm, Roger Cuypers wrote:
> the database has a root file. The subfiles are all loaded via separate
> connections as far as I know.
Sorry, but this makes no sense. Each database file can have only one WAL file.
You say that the program is looking through lots of WAL
I think it does at some point. I’m at home right now so I have to check this
again tomorrow when I have access to the source.
Should there be rbu calls if the application is only _reading_ fro the database
and not updating?
> Am 19.09.2018 um 21:48 schrieb Dan Kennedy :
>
> On 09/20/2018
Ok, hosed over by proguard once again. Needed to make sure the following
was in my proguard-project.txt file:
-keep class org.sqlite.** { *; }
Oh man! I must be getting old.
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
Hello,
the database has a root file. The subfiles are all loaded via separate
connections as far as I know.
Another idea of mine:
If I know the database will be only written to very rarely, can I prevent
sqlite from using the WAL files at all in the meantime?
> Am 19.09.2018 um 21:36 schrieb
Schuhmacher, Bernd wrote:
>
> I am trying to put up a little program using System.data.SQLite with C#
> under Visual Studio 2017. The Target Framework is dotnet core 2.0
> I imported the nuget Package (Project - manage nuget Package ...) into
> the Project.
> The compilation works fine. But if
On 09/19/2018 03:54 AM, David White wrote:
On 09/19/2018 12:18 AM, David White wrote:
I am stuck trying to use the precompiled binaries + Android bindings on
Android 8. Does anyone know how to reach the maintainers for this stuff?
Posting here will work.
I have posted a ticket on the wiki
Oops. Just sent this from the wrong email account. Sorry for any
duplication.
Hi Dan and thanks again for your response.
So far, I have heard this from only a single user. Silly Google no
longer seems to produce ARM system images for the emulator so I cannot
test as my computers are all AMD.
In tclsqlite.c, function DbMain()... somewhere between 3.19 and 3.23 there was
a re-write of the argument parsing code for the sqlite command, and following
code was removed and not completely replaced with a new equivalent:
if( objc<3 || (objc&1)!=1 ){
Tcl_WrongNumArgs(interp, 1, objv,
Dan,
Please don't waste your time on this thread any more at this point. My
last post made me think enough (what a concept!) to look at the
classes.dex in my exported .apk and there is something not right. It is
way too small. So I think something in my build is messed up. That would
explain
Hi
I am trying to put up a little program using System.data.SQLite with C# under
Visual Studio 2017. The Target Framework is dotnet core 2.0
I imported the nuget Package (Project - manage nuget Package ...) into the
Project.
The compilation works fine. But if running the compiled program I get
On 2018-09-19 2:30 PM, Brad Spencer wrote:
Disclaimer: I haven't yet tried this with the pre-release version of
sqlite-3.25.1, but I wanted to report it before the 24 hours of that
release notice expired.
I grabbed https://www.sqlite.org/2018/sqlite-src-3250100.zip and tried
this and result
Disclaimer: I haven't yet tried this with the pre-release version of
sqlite-3.25.1, but I wanted to report it before the 24 hours of that
release notice expired.
In sqlite-3.25.0, the release notes say the following:
"Fix table rename feature so that it also updates references to the
renamed
--
-- bug1:
select cast(cast(1.7976931348623157e+308 as text) as real); --
1.7976931348623157e+308 is internally formatted as
1.79769313486232e+308 which >then< is bigger than REAL.max_value so it is
parsed as 'Inf'
-- expected: 1.7976931348623157e+308
-- actual output: Inf
--
-- bug2:
select
Hi Dan and thanks again for your response.
So far, I have heard this from only a single user. Silly Google no
longer seems to produce ARM system images for the emulator so I cannot
test as my computers are all AMD. So I cannot say about that. Wish I
could. I have tried.
Here is the device
I'm trying to optimize a C++ application that uses sqlite 3 for database
access. As far as I know it uses journaling with WAL and has a lot of
files/tables (about 400). Profiling this application with Linux perf, I found
that it spends about 30% of its time inside the rbuFindMaindb function of
On 19 Sep 2018, at 7:49pm, Roger Cuypers wrote:
> As far as I know it uses journaling with WAL and has a lot of files/tables
> (about 400).
Excuse the low-end questions, but they might help save us a lot of silly
suggestions.
Does SQLite have lots of these open at one time ? If so, does it
On 09/20/2018 01:49 AM, Roger Cuypers wrote:
I'm trying to optimize a C++ application that uses sqlite 3 for database
access. As far as I know it uses journaling with WAL and has a lot of
files/tables (about 400). Profiling this application with Linux perf, I found
that it spends about 30% of
Hi List,
When investigating performance of one of our queries I found an interesting
situation that might be an opportunity for performance improvement.
Tested with Sqlite version 3.15.2 (November 2016).
Consider the following table and query
CREATE TABLE Node
(
Id INTEGER
Hi,
The JSON1 docs at https://www.sqlite.org/json1.html have a minor typo:
Section 4.13. The json_each() and json_tree() table-valued functions
atom ANY, -- value for primitive types, null for array & object
> id INTEGER -- integer ID for this element
> parent INTEGER, -- integer ID for the
19 matches
Mail list logo