Hello, Rene
> Hi there,
>
> I have to store and retrieve up to 2000 parameters.
> The parameters can have real and integer values.
> The max. change rate is 100ms and the max. duration is up to some hours.
>
> The simple solution would be to use plain binary files. It's fast but not
>
Thank you very much for the explanation and tips, they are appreciated.
Dne 9.12.2014 v 14:30 Richard Hipp napsal(a):
> Answered by adding a comment at
> https://bugzilla.redhat.com/show_bug.cgi?id=1161844
>
> On Tue, Dec 9, 2014 at 6:06 AM, Jan Staněk wrote:
>
> Hi,
> some
Dear folks,
A little SQL question for you. The database file concerned is purely for data
manipulation at the moment. I can do anything I like to it, even at the schema
level, without inconveniencing anyone.
I have a TABLE with about 300 million (sic.) entries in it, as follows:
CREATE
Hi Simon,
Am 10.12.2014 12:39, schrieb Simon Slavin:
Dear folks,
A little SQL question for you. The database file concerned is purely for data
manipulation at the moment. I can do anything I like to it, even at the schema
level, without inconveniencing anyone.
I have a TABLE with about
Both, I guess
Insert into ... select a,b,sum(theCount) group by a,b;
-Ursprüngliche Nachricht-
Von: Simon Slavin [mailto:slav...@bigfraud.org]
Gesendet: Mittwoch, 10. Dezember 2014 12:39
An: General Discussion of SQLite Database
Betreff: [sqlite] replace many rows with one
Dear folks,
On 2014/12/10 13:39, Simon Slavin wrote:
Dear folks,
A little SQL question for you. The database file concerned is purely for data
manipulation at the moment. I can do anything I like to it, even at the schema
level, without inconveniencing anyone.
I have a TABLE with about 300 million
I just noticed that the version links for the last two releases at:
http://sqlite.org/news.html
seem to be cut/paste errors, 3.8.7.3 and 3.8.7.4 both have links to
the 3.8.7.2 release.
--
Kyle
___
sqlite-users mailing list
sqlite-users@sqlite.org
I realize that sqlar is not intended as a production quality tool. That
being said, I was doing some experiments today and encountered a bug (at
least on FreeBSD, not sure if Linux is impacted).
In the function add_file it checks if a filename is a directory. If so, it
calls opendir, and if
On Wed, Dec 10, 2014 at 4:58 PM, Scott Robison
wrote:
> I realize that sqlar is not intended as a production quality tool. That
> being said, I was doing some experiments today and encountered a bug (at
> least on FreeBSD, not sure if Linux is impacted).
>
> In the
On Wed, Dec 10, 2014 at 3:07 PM, Richard Hipp wrote:
> On Wed, Dec 10, 2014 at 4:58 PM, Scott Robison
> wrote:
>
> > In the function add_file it checks if a filename is a directory. If so,
> it
> > calls opendir, and if successful, loops on readdir. But
On 10 Dec 2014, at 02:36, Simon Slavin wrote:
>
> On 10 Dec 2014, at 12:30am, Nick wrote:
>
>> That's interesting Simon I didn't expect the database not to be trustworthy.
>
> The database will be trustworthy at any instant. Your copy of it will be
> corrupt because
On 10 Dec 2014, at 07:35, Dan Kennedy wrote:
> Strictly speaking the database file may not be well-formed even if there is
> no ongoing checkpoint. If:
>
> a) process A opens a read transaction,
> b) process B opens and commits a write transaction to the database,
> c) process C checkpoints
12 matches
Mail list logo