On 2015-03-30 11:46 AM, Jeff Roux wrote:
> Hi everyone,
>
> I have a daemon that collects information and stores it in a SQLite
> database. The table has 1 million rows.
>
> This daemon is running on a HP server with 12 cores, 32 GB of RAM,
> and a SSD drive. I have performance issues with some
Simon,
here is the list of the indexes that were already defined on the table:
CREATE INDEX idxLanWan ON flows(ipLan, ipWan, portWan, portLan);
CREATE INDEX idxProto ON flows(protocol);
CREATE INDEX idxTos ON flows(tos);
CREATE INDEX idxTsLanWan ON flows(timestamp, ipLan, ipWan, portWan,
> You explicitly put strings into both columns. The two values are the same
> even though you declared the columns differently. As I told you before,
> if you want to see what type something is, use typeof(thing).
>
> ~
> ~
> ~
> ~
>
> Simon.
Thank you guys. I follow this list so I
Hi everyone,
I have a daemon that collects information and stores it in a SQLite
database. The table has 1 million rows.
This daemon is running on a HP server with 12 cores, 32 GB of RAM,
and a SSD drive. I have performance issues with some requests. For
instance, the following request takes
On 30 Mar 2015, at 10:46am, Jeff Roux wrote:
> This daemon is running on a HP server with 12 cores, 32 GB of RAM,
> and a SSD drive. I have performance issues with some requests. For
> instance, the following request takes more than 5 seconds to
> accomplish with SQlite3 (in that particular
On Thu, Mar 26, 2015 at 4:29 PM, Nigel Verity
wrote:
> My requirement is to take periodic snapshots of a names and addresses
> table, to be stored in the same database as the master.
>
Perhaps also look into https://www.sqlite.org/backup.html, which doesn't
qualify for "the same database", but
On Mon, Mar 30, 2015 at 6:44 AM, Jeff Roux wrote:
> Simon,
>
> here is the list of the indexes that were already defined on the table:
> CREATE INDEX idxLanWan ON flows(ipLan, ipWan, portWan, portLan);
> CREATE INDEX idxProto ON flows(protocol);
> CREATE INDEX idxTos ON flows(tos);
> CREATE
What cache_size have you specified?
---
Theory is when you know everything but nothing works. Practice is when
everything works but no one knows why. Sometimes theory and practice are
combined: nothing works and no one knows why.
>-Original Message-
>From: sqlite-users-bounces at
8 matches
Mail list logo