Is features like WAL (https://www.sqlite.org/wal.html) not available for in
memory databases ?
Thanks
Prakash
On Fri, Oct 17, 2014 at 11:23 AM, Alessandro Marzocchi
alessandro.marzoc...@gmail.com wrote:
Today, random-access memory takes the form of integrated circuits
Hi,
Let's take the case of MemSQL for example. It is an in memory database and
it supports durability:
Link : http://developers.memsql.com/docs/3.1/faq.html#c3-q1
And Oracle's In memory db TimesTen also provide durability:
Link :
if it uses disk, it can be persistant. If it's in memory, it's only as
reliable as the power to the computer. If it's in memory and cached to
disk, it's really a disk database. Just because someone says 'we have a
memory database, that's the primary and disk is secondary' it's still a
disk
Hi all
Trying to use strftime() to extract current Year-Month seems to go nuts. Any
ideas?
$ sqlite3
SQLite version 3.6.20
Enter .help for instructions
Enter SQL statements terminated with a ;
sqlite select strftime('%s', 'now');
1413536061
sqlite -- fine, but
sqlite select strftime('%Y-%m',
Roy Sigurd Karlsbakk wrote:
Trying to use strftime() to extract current Year-Month seems to go nuts.
sqlite select strftime('%s', 'now');
1413536061
sqlite select strftime('%Y-%m', strftime('%s', 'now'));
3865-46
SQLite interprets a number as a Julian day number. To have it
interpreted as
From memsql site:
These features can be tuned all the way from synchronous durability (every
write transaction is recorded on disk before the query completes) to purely
in-memory durability (maximum sustained throughput on writes).
From sqlite website:
The MEMORY journaling mode stores the
Thanks Alessandro.
So the approach where we open the db with :memory: keyword does not
provide durability .
Only by increasing the cache size can we make db act as an inmemory db with
durablity. That's the conclusion right ?
Thanks
Prakash
On Fri, Oct 17, 2014 at 2:53 PM, Alessandro Marzocchi
Joe Mistachkin wrote:
Thanks for the query. It's difficult to track down performance issues with
System.Data.SQLite without seeing the C# (or VB.NET) example code as there are
a variety of ways to query and process data using it.
Is there any chance we could see the code that is using
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of Kraijenbrink - FixHet - Systeembeheer
Sent: vrijdag 17 oktober 2014 12:01
To: General Discussion of SQLite Database
Subject: Re: [sqlite] group_concat query performance
On Thu, 16 Oct 2014 18:46:19 +0530, Prakash Premkumar
prakash.p...@gmail.com wrote:
Hi,
From what I understand from reading the followig doc:
http://www.sqlite.org/lockingv3.html
sqlite supports only file level locking.
Correct.
Is there any attempts to improve
the granularity of locking
Thanks Bert,
You are right. Now the C++ example runs equaly fast. Looks like I have to
redesign the Db schema.
With regards,
Peter
Where do you perform the query in the C++ code?
Your C++ program shows how you prepare the statement 5000 times, but not how
you execute it.
The VB.Net code
On Thu, 16 Oct 2014 09:05:51 +1100
Michael Falconer michael.j.falco...@gmail.com wrote:
we just wonder if there is a better way to perform this search in
SQL. Is there a general technique which is superior either in speed,
efficiency or load bearing contexts?
The simple answer is No, because
On 17 Oct 2014, at 10:39am, Prakash Premkumar prakash.p...@gmail.com wrote:
So the approach where we open the db with :memory: keyword does not
provide durability .
Only by increasing the cache size can we make db act as an inmemory db with
durablity. That's the conclusion right ?
No. The
On 17 Oct 2014 at 10:39, Prakash Premkumar prakash.p...@gmail.com wrote:
So the approach where we open the db with :memory: keyword does not
provide durability.
Why is that any sort of surprise? What you're opening is a database called
:memory:. The string :memory: is the name of the
FTS MATCH was a great solution to that particular problem. Thanks again, Dr.
Hipp!
Back to original question... Is it at all possible to pass the results of a
SELECT to a WHERE expression? I have used a SELECT to create a full statement
but then I have to copy the result to a query editor and
On 10/16/2014 12:03 PM, Tom Holden wrote:
I need a way to convert the text result to an expression that WHERE
evaluates as an expression.
Any possibility to do this within SQLite?
with recursive split(str, tail) as (
select null, 'string1+string2+string3'
union all
select substr(tail, 1,
I have a virtual table implementation, and I would like to use the INSERT OR
REPLACE syntax to simplify actions for the user. In my xUpdate method, for
the case where insertion is occuring,
else if ( argc 1 SQLITE_NULL == sqlite3_value_type ( argv[0] ) ) {
I do check a uniqueness constraint,
Greetings!
I have a program that takes bilingual files and looks for the source strings
and reports on the multiples target translations of that source string. For
example:
Hello, Hola
Hello, Hola
Hello, Hola!
Hello, DÃmelo!
Hello, Y entoces!
Hello, y que!
Good Bye, Hasta luego
Good Bye,
On 10/18/2014 01:07 AM, dave wrote:
I have a virtual table implementation, and I would like to use the INSERT OR
REPLACE syntax to simplify actions for the user. In my xUpdate method, for
the case where insertion is occuring,
else if ( argc 1 SQLITE_NULL == sqlite3_value_type ( argv[0] ) ) {
...
On 10/18/2014 01:07 AM, dave wrote:
I have a virtual table implementation, and I would like to
use the INSERT OR
REPLACE syntax to simplify actions for the user. In my
xUpdate method, for
the case where insertion is occuring,
...
on a virtual table, or something else, or maybe
No big deal, but on line 885 of shell.c, did you really mean to test if azArg
(of type char**) was greater than 0 rather than not equal to 0? It throws a
warning on Solaris 9 with the SUNPro compiler.
On Friday, October 17, 2014 10:00 AM, D. Richard Hipp d...@hwaci.com wrote:
SQLite
Thanks for the report. The bug you found is probably harmless on most
systems. But it is certainly worth fixing.
http://www.sqlite.org/src/info/19fe4a0a475bd94
On Fri, Oct 17, 2014 at 5:11 PM, Peter Aronson pbaron...@att.net wrote:
No big deal, but on line 885 of shell.c, did you really mean
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of Kraijenbrink - FixHet - Systeembeheer
Sent: vrijdag 17 oktober 2014 16:46
To: General Discussion of SQLite Database
Subject: Re: [sqlite] group_concat query performance
I am glad I posted the question.
Yes James, there is little I can disagree with in your excellent summary.
Even the critique of my perhaps poorly framed question is indeed valid. I
take your point regarding spec vs implementation, and in my experience
across different rdbms's I have frequently
Igor, that is a most oblique and intriguing approach. I will try it out and
try to get my head around it in the next day or so.
Thanks,
Tom
Igor Tandetnik-2 wrote
On 10/16/2014 12:03 PM, Tom Holden wrote:
I need a way to convert the text result to an expression that WHERE
evaluates as an
25 matches
Mail list logo