Re: [sqlite] 64bit compatibility warnings

2013-04-07 Thread Alexandr Němec
Hi all,   thanks for your replies, but unfortunately they did not answer my original question whether these warnings are harmless and can be ignored or not. These warnings reported by the VS C++ compiler are about "possible loss of data", so it is a situation when a "int64" expression result is

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.85.0 have begun...

2013-04-07 Thread Joe Mistachkin
If you have any issues with the current code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/";) prior to this Friday, April 12th. Thanks. -- Joe Mistachkin ___ sqlite-users mailing list sqlite

Re: [sqlite] SQL Logic error or missing database

2013-04-07 Thread Pavel Ivanov
Do you know that VS2012 has known optimizer bugs? Pavel On Apr 6, 2013 5:01 AM, "ibrahim" wrote: > On 05.04.2013 17:01, Dan Kennedy wrote: > >> On 04/05/2013 09:08 PM, Rob Collie wrote: >> >>> Yeap, I'm on Visual Studio 2012. I've created a console app: >>> >>> >>> sqlite3 *oDatabase; >>> in

Re: [sqlite] Partial sorting

2013-04-07 Thread Baruch Burstein
I was thinking more of general (not just LIMIT 1) optimization: http://en.wikipedia.org/wiki/Partial_sorting On Sun, Apr 7, 2013 at 6:16 PM, Simon Slavin wrote: > > On 7 Apr 2013, at 3:51pm, Stephen Chrzanowski wrote: > > > I don't know if it'd be an interesting optimization. Who's to say what

Re: [sqlite] SQLite 3.7.17 preview - 2x faster?

2013-04-07 Thread Max Vlasov
On Sun, Apr 7, 2013 at 3:55 PM, Chris Smith wrote: > Possibly related: > http://en.wikipedia.org/wiki/Thrashing_(computer_science) > > That's an interesting direction. Surprisingly if one query ... site:microsoft.com "Thrashing" "memory-mapped"... on google, he or she would find a forum topic "Me

Re: [sqlite] Partial sorting

2013-04-07 Thread Simon Slavin
On 7 Apr 2013, at 6:56pm, Richard Hipp wrote: > It uses a btree as a priority queue. If you have LIMIT N, then it > initially starts putting results into the btree until the btree contains N > entries. Then for each additional row, it first adds the value to the > btree, then removes the large

Re: [sqlite] 64bit compatibility warnings

2013-04-07 Thread Simon Slavin
On 7 Apr 2013, at 6:26pm, f...@cetussoft.com wrote: >> I think that in general it might be a good idea to update the code to >> not produce any 64 bit portability warnings, so that we know for sure, >> that compiling 64 bit does not introduce any 64 bit side effects or possible >> bugs. > > ...

Re: [sqlite] SQLite 3.7.17 preview - 2x faster?

2013-04-07 Thread Chris Smith
Possibly related: http://en.wikipedia.org/wiki/Thrashing_(computer_science) On Sun, Apr 7, 2013 at 6:25 AM, Jean-Christophe Deschamps wrote: > Hi Max, > > The link is dead. I'd like to know more about this so can you provide us > with a live link? > > Thanks. > > > __

Re: [sqlite] Partial sorting

2013-04-07 Thread Richard Hipp
On Sun, Apr 7, 2013 at 9:08 AM, Baruch Burstein wrote: > If I issue a select statement with a ORDER BY clause and a LIMIT clause, > does SQLite do a full sort (assuming no index) and then return the first X > rows, or just a partial sort to get the first X sorted results? > It uses a btree as a p

Re: [sqlite] 64bit compatibility warnings

2013-04-07 Thread fred
> I think that in general it might be a good idea to update the code to > not produce any 64 bit portability warnings, so that we know for sure, > that compiling 64 bit does not introduce any 64 bit side effects or possible > bugs. ...as long as doing so does not break 32-bit code... Fred _

Re: [sqlite] Partial sorting

2013-04-07 Thread Clemens Ladisch
Stephen Chrzanowski wrote: > I don't know if it'd be an interesting optimization. Who's to say what the > order ends up as prior to the sort? When doing a merge sort, it would actually be possible to abort the very last merge step when the first LIMIT entries have been merged. I might be wrong,

[sqlite] 64bit compatibility warnings

2013-04-07 Thread Alexandr Němec
Dear all,   when compiling the latest 3.7.16.1 version of SQLite, the VS compiler complains about some 64 bit portability issues, see below. May these warning be safely ignored when compiling 64 bit? All warnings refer to the sqlite3.c amalgamation file. Thanks in advance.   Line 6766   u.bc

Re: [sqlite] Partial sorting

2013-04-07 Thread Simon Slavin
On 7 Apr 2013, at 3:51pm, Stephen Chrzanowski wrote: > I don't know if it'd be an interesting optimization. Who's to say what the > order ends up as prior to the sort? Take for example if I have a list of > dollars and cents being returned from a query. I want the 5 top highest > cost items o

Re: [sqlite] Partial sorting

2013-04-07 Thread Stephen Chrzanowski
I don't know if it'd be an interesting optimization. Who's to say what the order ends up as prior to the sort? Take for example if I have a list of dollars and cents being returned from a query. I want the 5 top highest cost items out of 6 possibilities, if I keep the top 5 unsorted, item 6 coul

Re: [sqlite] SQLite 3.7.17 preview - 2x faster?

2013-04-07 Thread fred
> The link is dead. I'd like to know more about this so can you provide us > with a live link? The problem is the closing parenthesis has become part of the link in Max's first email - remove it in your browser URL window and the link works fine. Or - http://social.msdn.microsoft.com/Forums/en-U

Re: [sqlite] Partial sorting

2013-04-07 Thread Simon Slavin
On 7 Apr 2013, at 2:08pm, Baruch Burstein wrote: > If I issue a select statement with a ORDER BY clause and a LIMIT clause, > does SQLite do a full sort (assuming no index) and then return the first X > rows, or just a partial sort to get the first X sorted results? The ORDER BY clause does not

[sqlite] Partial sorting

2013-04-07 Thread Baruch Burstein
If I issue a select statement with a ORDER BY clause and a LIMIT clause, does SQLite do a full sort (assuming no index) and then return the first X rows, or just a partial sort to get the first X sorted results? -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı ___

Re: [sqlite] SQLite 3.7.17 preview - 2x faster?

2013-04-07 Thread Max Vlasov
don't know what's wrong with the link, I'm clicking the one from gmail thread and it works. Other way is to google [Unresponsive system under some file-mapping related conditions] and the first result is the thread link Max On Sun, Apr 7, 2013 at 2:25 PM, Jean-Christophe Deschamps wrote: > Hi M

Re: [sqlite] SQLite 3.7.17 preview - 2x faster?

2013-04-07 Thread Jean-Christophe Deschamps
Hi Max, The link is dead. I'd like to know more about this so can you provide us with a live link? Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 3.7.17 preview - 2x faster?

2013-04-07 Thread Max Vlasov
On Thu, Apr 4, 2013 at 4:02 PM, Richard Hipp wrote: > By making use of memory-mapped I/O, the current trunk of SQLite (which will > eventually become version 3.7.17 after much more refinement and testing) > can be as much as twice as fast, on some platforms and under some > workloads. We would l