Re: [sqlite] Small Performance Regression (3.21.0)

Am 27.10.2017 um 21:59 schrieb David Raymond: Also getting 31ms for both... Thanks for testing that guys... I was able to get similar timings (about 30msec), when the (quite large) resultset-output was delegated into a file... To avoid doing expensive File-IO in that test, I'd recommend to

[sqlite] sqlite 3.21.0 bug? SELECT CAST ('9223372036854775807 ' AS NUMERIC);

sqlite 3.21.0, built from source on Scientific Linux 6 (which is derived from Red Hat Enterprise Linux 6). configure options were: --enable-threadsafe --enable-threads-override-locks --enable-load-extension CFLAGS="-DSQLITE_ENABLE_COLUMN_METADATA=1 -DSQLITE_DISABLE_DIRSYNC=1

Re: [sqlite] Small Performance Regression (3.21.0)

Also getting 31ms for both. Though looking at the explain output it looks like for the view/subroutine/subquery version it's spending extra machine steps copying every result row from one set of registers to another. Below this point only gratuitous stats and query plans From the View

Re: [sqlite] Small Performance Regression (3.21.0)

Thanks for the report. Do you have any other interesting, complex, or slow queries using your database that you can send me for testing purposes? On 10/27/17, Olaf Schmidt wrote: > The new CoRoutine-approach seems to slow down certain > ViewDefinitions (in comparison to

Re: [sqlite] Small Performance Regression (3.21.0)

I don't see any difference in the runtimes, at least not with the current head of trunk ... sqlite> .once x sqlite> select * from invoices; Run Time: real 0.032 user 0.031250 sys 0.00 sqlite> .once y sqlite> SELECT ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry,

[sqlite] Small Performance Regression (3.21.0)

The new CoRoutine-approach seems to slow down certain ViewDefinitions (in comparison to running a Query directly). FWIW, here's a download-link to an NorthWind-SQLite-DB, which already contains certain view-definitions: http://vbRichClient.com/Downloads/NWind.zip (an "Analyze"-command was

Re: [sqlite] Typo & missing link

Thanks. The README has now been converted into a README.md and has been updated with the latest project status and the typo has been fixed. On 10/27/17, Mark Summerfield wrote: > On this page: > > https://sqlite.org/src4/tree?ci=trunk > > It says: > > The developers do not

[sqlite] Typo & missing link

On this page: https://sqlite.org/src4/tree?ci=trunk It says: The developers do not use teh configure script. Which has a typo; should be: The developers do not use the configure script. Also, this page mentions linux and windows binaries, but provides no link to them. Nor can I find

Re: [sqlite] BedrockDB interview on Floss Weekly

Correction: On 2017/10/27 12:57 PM, R Smith wrote: [1]: PHP doesn't understand BedrockDB yet, but it understands SQLite / MySQL and Bedrock uses SQLite and has a MySQL connector. I stand corrected, Bedrock does provide a PHP binding. From the website: Bedrock also provides a PHP binding

Re: [sqlite] BedrockDB interview on Floss Weekly

On Oct 26, 2017, at 12:15 AM, David Barrett wrote: > > I'm glad you liked it! I'd be happy to answer any questions you have about > http://BedrockDB.com, our use of sqlite, or anything else. Thanks for > listening! Before I get to the questions, I haven’t listened to

Re: [sqlite] BedrockDB interview on Floss Weekly

Thanks Ryan - a handy summary. Food for thought. Thanks, Chris On Fri, Oct 27, 2017 at 11:57 AM, R Smith wrote: > > On 2017/10/27 11:52 AM, Bart Smissaert wrote: > >> Is this BedrockDB something that could be used to connect to a server and >> run SQL and avoid the

Re: [sqlite] BedrockDB interview on Floss Weekly

On 2017/10/27 11:52 AM, Bart Smissaert wrote: Is this BedrockDB something that could be used to connect to a server and run SQL and avoid the problems (mainly slowness) that SQLite would have in this situation? and Chris Locke wrote: My work environment is mainly Windows servers/users.

Re: [sqlite] BedrockDB interview on Floss Weekly

My work environment is mainly Windows servers/users. SQLite 'works' but is obviously unsupported (file locking, etc). Could BedrockDb help in this area? Sounds like it works 'locally' but 'networkably' (is that a word?!) Couldn't find any Windows-friendly builds or guides. Even assuming it

Re: [sqlite] BedrockDB interview on Floss Weekly

Is this BedrockDB something that could be used to connect to a server and run SQL and avoid the problems (mainly slowness) that SQLite would have in this situation? RBS On Fri, Oct 27, 2017 at 10:40 AM, R Smith wrote: > > On 2017/10/27 7:19 AM, Wout Mertens wrote: > >>

Re: [sqlite] BedrockDB interview on Floss Weekly

On 2017/10/27 7:19 AM, Wout Mertens wrote: Interesting that you emulate mysql, given that sqlite tries to be postgresql compatible… It doesn't emulate MySQL, it has a MySQL connector so that you can connect it and do queries via your already-MySQL-using app. This is an add-on option, not