Re: [sqlite] sqlite versus MySQL automatic defragmentation on SSDs?

2012-10-30 Thread David Barrett
Ah, to clarify, there is only one "master" at any point in time. So this isn't a "multi-master" scenario where each node keeps committing locally and then somehow merging the results later. Rather, each node knows if it's the master or slave (or a variety of other states). If it's a master, it o

Re: [sqlite] light weight write barriers

2012-10-30 Thread Nico Williams
Hmm, so sorry I didn't notice the cc'ing of the linux-kernel list, resulting in so much additional traffic to sqlite-users, which I'll drop in my replies to the linux-kernel list. Nico -- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlit

Re: [sqlite] Union all writting on /var/tmp

2012-10-30 Thread Nico Williams
Also, as far as I'm concerned, if the choice is "more optimizations in SQLite3" or "more work on SQLite4", then put me down for the latter. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] light weight write barriers

2012-10-30 Thread Howard Chu
On Thu, Oct 25, 2012, Nico Williams wrote: Incidentally, here's a single-file, bag of b-trees that uses a COW format: MDB, which can be found in git://git.openldap.org/openldap.git, in the mdb.master branch. Complete docs, design notes, and benchmark results are available here: http://highlan

Re: [sqlite] Union all writting on /var/tmp

2012-10-30 Thread Nico Williams
On Mon, Oct 29, 2012 at 8:08 PM, Richard Hipp wrote: > The reason for using a temp table for UNION ALL in a subquery is because > that is the path of least resistance. [...] For what it's worth, UNION ALL is generally understood to be a major optimization over UNION because no temp table should

[sqlite] MyJSQLView Version 3.40 Released

2012-10-30 Thread danap
MyJSQLView Version 3.40 Released The MyJSQLView project is pleased to release v3.40 to the public. The release marks a major reorganizational effort to the source code and plugin management. Though the public will notice little with regard to the source subpackaging the plugin management changes b

Re: [sqlite] sqlite versus MySQL automatic defragmentation on SSDs?

2012-10-30 Thread Chris Peachment
On Wed, 2012-10-31 at 00:49 +0700, David Barrett wrote: > Thanks Alek! Yes, we're definitely planning on it, just trying to > find the right time. We don't want to go through the work to open > source it only to be greeted with silence. Might you be interested in > using it in an actual deployed

Re: [sqlite] sqlite versus MySQL automatic defragmentation on SSDs?

2012-10-30 Thread Simon Slavin
On 30 Oct 2012, at 5:15pm, David Barrett wrote: > I'm encouraged to hear > that there aren't any particular size restrictions or concerns. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.

Re: [sqlite] sqlite versus MySQL automatic defragmentation on SSDs?

2012-10-30 Thread David Barrett
On Tue, Oct 30, 2012 at 1:00 AM, Alek Paunov wrote: > On 29.10.2012 11:58, David Barrett wrote: > >> Because in practice, as someone actually doing it (as opposed to >> theorizing >> about it), it works great. The MySQL portions of our service are always >> in >> a semi-constant state of emergen

Re: [sqlite] sqlite versus MySQL automatic defragmentation on SSDs?

2012-10-30 Thread David Barrett
On Mon, Oct 29, 2012 at 8:28 PM, Richard Hipp wrote: > On Mon, Oct 29, 2012 at 5:58 AM, David Barrett >wrote: > > So what specifically do you feel is the problem with sqlite at scale? > > > > And to be clear, I'd like to pre-empt "well it doesn't do X, which you'll > > probably also want to do"

Re: [sqlite] Union all patch, preliminary tests

2012-10-30 Thread Richard Hipp
Thanks for running these tests. Clearly I should have made this change a long time ago On Tue, Oct 30, 2012 at 9:31 AM, Eleytherios Stamatogiannakis < est...@gmail.com> wrote: > In my preliminary tests, the patch has worked wonderfully. In these first > tests i have only tested plain SQLite

[sqlite] Union all patch, preliminary tests

2012-10-30 Thread Eleytherios Stamatogiannakis
In my preliminary tests, the patch has worked wonderfully. In these first tests i have only tested plain SQLite functionality (without virtual table or additional functions) on a 1.5GB DB. Some remarks: - It is lightning fast. For queries that fit to the free space (some of them could not fini

Re: [sqlite] sqlite eclipse

2012-10-30 Thread Black, Michael (IS)
Sounds ilke you're using a 64-bit JDK. Use the 32-bit JDK. That's what the error is telling you64-bit can't load 32-bit DLL. As long as all your code is 32-bit it will run on 32-bit. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit North

[sqlite] sqlite eclipse

2012-10-30 Thread Kemayou Nyamen, Carine, WO
Hello, I want to connect to my database sqlite via eclipse. I write a java programm, but It is not possible, I read the Instruction on this site Connecting to SQLite - Eclipsepedia , but when I make test connection, the error is ping failed. By r

Re: [sqlite] Union all writting on /var/tmp

2012-10-30 Thread Richard Hipp
On Tue, Oct 30, 2012 at 7:39 AM, Eleytherios Stamatogiannakis < est...@gmail.com> wrote: > > Mr. Hipp please excuse my attitude on my first email > All is forgotten. Thank you for bringing this optimization opportunity to our attention! -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] Union all writting on /var/tmp

2012-10-30 Thread Eleytherios Stamatogiannakis
Hello, Mr. Hipp please excuse my attitude on my first email (the one your replied to). It came after 3 days of intense pressure to find out what the problem of machines coming to a crawl whenever a particular query with sufficiently large union-ed all tables was run. Due to the quality of SQ