On Mon, 21 Oct 2019 at 23:28, Jonathan Brandmeyer
wrote:
> Or, how many times is each page written by SQLite for an insert-heavy
> test? The answer appears to be "4", but I can only account for two of
> those four.
>
> I'm working on an embedded system that uses a log-structured
> filesystem on
On 10/21/19, Jonathan Brandmeyer wrote:
>
> No significant change. The target filesystem only caches non-aligned
> writes, so there usually isn't anything for it to do on fsync anyway.
>
OK. I don't have any more ideas at the moment, and without access to
your code, and your platform, I can't r
On Mon, Oct 21, 2019 at 5:00 PM Richard Hipp wrote:
>
> On 10/21/19, Jonathan Brandmeyer wrote:
> > On Mon, Oct 21, 2019 at 10:31 AM Richard Hipp wrote:
> >>
> >> On 10/21/19, Jonathan Brandmeyer wrote:
> >> > Or, how many times is each page written by SQLite for an insert-heavy
> >> > test? T
On 10/21/19, Jonathan Brandmeyer wrote:
> On Mon, Oct 21, 2019 at 10:31 AM Richard Hipp wrote:
>>
>> On 10/21/19, Jonathan Brandmeyer wrote:
>> > Or, how many times is each page written by SQLite for an insert-heavy
>> > test? The answer appears to be "4", but I can only account for two of
>> >
On Mon, Oct 21, 2019 at 10:31 AM Richard Hipp wrote:
>
> On 10/21/19, Jonathan Brandmeyer wrote:
> > Or, how many times is each page written by SQLite for an insert-heavy
> > test? The answer appears to be "4", but I can only account for two of
> > those four.
>
> Are you measuring writes at the
On 10/20/19 11:03 PM, Rowan Worth wrote:
> On Sun, 20 Oct 2019 at 17:04, Simon Slavin wrote:
>
>> Another common request is full support for Unicode (searching, sorting,
>> length()). But even just the tables required to identify character
>> boundaries are huge.
>>
> Nitpick: there are no tables
On 10/21/19, Jonathan Brandmeyer wrote:
> Or, how many times is each page written by SQLite for an insert-heavy
> test? The answer appears to be "4", but I can only account for two of
> those four.
Are you measuring writes at the OS-interface layer, or writes at the
hardware layer? SQLite shoul
Or, how many times is each page written by SQLite for an insert-heavy
test? The answer appears to be "4", but I can only account for two of
those four.
I'm working on an embedded system that uses a log-structured
filesystem on raw NAND flash. This is not your typical workstation's
managed flash
Hello,
compiling the latest stable version 3300100 using VS2019 on Windows and ICC
2019 Update 5 gives this warning:
1>-- Rebuild All started: Project: SQLite DLL, Configuration: Release x64
--
1>sqlite3.c
1>C:\Dropbox\Boo\Shares\Code\SQLite\SQLite DLL\sqlite3.c(154619): message #111:
Hello,
I would appreciate any help in finding why I get an error when saving back
to a database.
I am using vb.net in VS-2019 with sqlite.
The error is: "Concurrency violation: the UpdateCommand affected 0 of the
expected 1 records."
I have worked out that the error only occurs whe
> Not a clue. I didn't write the schema.
I know, I asked the OP.
RBS
On Mon, Oct 21, 2019 at 4:16 PM Keith Medcalf wrote:
>
> On Monday, 21 October, 2019 08:47, Bart Smissaert <
> bart.smissa...@gmail.com> wrote:
>
> >Shouldn't there be field MODE_ID in the Employee table?
>
> Not a clue. I
On Monday, 21 October, 2019 08:47, Bart Smissaert
wrote:
>Shouldn't there be field MODE_ID in the Employee table?
Not a clue. I didn't write the schema. Perhaps there is another table called
MODATES that has a link to the employee (EMPLOYEE_ID) and a link to the mode
(MODE_ID) together wit
> Shouldn't there be field MODE_ID in the Employee table?
>
It looks like a high school homework to me :D
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Shouldn't there be field MODE_ID in the Employee table?
RBS
On Mon, Oct 21, 2019 at 3:44 PM Keith Medcalf wrote:
>
> On Monday, 21 October, 2019 08:31, Winfried wrote:
>
> >Using the following tables, I need to find how employees from each city
> >come to work.
>
> >== Employees table:
> >
On Monday, 21 October, 2019 08:31, Winfried wrote:
>Using the following tables, I need to find how employees from each city
>come to work.
>== Employees table:
>EMPLOYEE_ID | CITY_ID
>Cities table:
>CITY_ID | CITY_TXT
>Mode table:
>MODE_ID | MODE_TXT
>
>This is the type of output I need to
Hello,
Before I dive into https://www.sqlitetutorial.net, I'd like to check with
experienced users whether SQLite is up to the task, or I should maybe run
multiple queries possibly with some help from PHP.
Using the following tables, I need to find how employees from each city come
to work.
=
Zakrzewski, Jakub wrote
> It's because `execute()` returns a boolean (as stated in the manual
> https://www.php.net/manual/en/pdostatement.execute.php ). `fetch()` must
> be called on `$query`
Thanks much!
=
$query = $dbh->prepare("SELECT mode_txt FROM mode WHERE mode_id=? LIMIT 1");
$que
It's because `execute()` returns a boolean (as stated in the manual
https://www.php.net/manual/en/pdostatement.execute.php ).
`fetch()` must be called on `$query`
From: sqlite-users on behalf of
Winfried
Sent: 21 October 2019 11:47
To: sqlite-users@mail
Hello,
I can't figure out why PHP isn't happy with the following query:
==
prepare('INSERT INTO mytable (date, home_id, mode_id) VALUES
(?, ?, ?)');
$query->execute(array($today,$home, $mode));
//CREATE TABLE mode (mode_id INTEGER, mode_txt TEXT);
//SELECT OK
//$query = $dbh->prepare
>
> For a (meaningful, as opposed to "all interpolated values") granularity of
> 1 hour, information theory states that you need a sample every 30 minutes
> or less.
>
> The desire to charge consumers more for "peak power" (just like utilities
> have to pay more for "peak power" and less for "base
On Monday, 21 October, 2019 00:49, Hick Gunter wrote:
>The desire to charge consumers more for "peak power" (just like utilities
>have to pay more for "peak power" and less for "base load") is the
>driving force behind the installation of "smart meters".
This is the propaganda behind "smart me
21 matches
Mail list logo