Re: [sqlite] Mailing list shutting down...

2018-06-14 Thread Jeffrey Schiller
I am so offering... -Jeff On Wed, Jun 13, 2018 at 12:42 PM Richard Hipp wrote: > On 6/13/18, Michael Tiernan wrote: > > May I respectfully suggest to everyone that offering solutions, while > > valuable and helpful, may not be as valuable as the offer of assistance > > to our listmaster. > >

Re: [sqlite] Mailing list shutting down...

2018-06-14 Thread Jeffrey Schiller
The latest version of Mailman does implement a Captcha (via reCaptcha). Also, if you set mm_cfg.SUBSCRIBE_FORM_SECRET to a secret value, Mailman will insist that the subscription form be submitted after a slight delay, which defaults to 5 seconds. This features exists in the version currently used

Re: [sqlite] .timer

2018-06-14 Thread Warren Young
On Jun 14, 2018, at 12:31 PM, x wrote: > > It is Windows Defender I’m using So does the symptom go away when you turn Defender off? I would not expect it to, but let’s close the loop on this, okay? > a ms surface pro 4 with 16 GB ram and 512 GB SSD I think we can provisionally rule out

Re: [sqlite] .timer

2018-06-14 Thread Simon Slavin
On 14 Jun 2018, at 10:04pm, Simon Slavin wrote: > Now do exactly the same test, but have the file stored on a USB Flash drive > instead of the boot volume. You should be able to do something like > > .open d:\MyTemp.db > > See how this influences any change. Oh, also try the same drive but

Re: [sqlite] .timer

2018-06-14 Thread Keith Medcalf
See the following web page for how the default "Microsoft Magical Mystery Cache Mode" works on Windows. The term "Intelligent Read-Ahead" applies only if you are 12 years old (typical Microsoft behaviour). http://flylib.com/books/en/4.491.1.101/1/ Note that the default mode is completely

Re: [sqlite] .timer

2018-06-14 Thread Simon Slavin
On 14 Jun 2018, at 7:31pm, x wrote: > Why is using ‘RowID desc’ so much slower than ‘RowID asc’ after a ‘reboot’? I > get the impression Windows is caching the pages from the ‘desc’ but not the > ‘asc’ and that’s what’s slowing it down. On this particular journey I’ve come > across tables

Re: [sqlite] .timer

2018-06-14 Thread Keith Medcalf
Cannot reproduce. I am using the current trunk that I compile myself with MinGW 8.1.0 on Windows 10 1803 Pro for Workstations. The laptop has a 4 Ghz Quad Core Xeon and the disk is a Samsung NVMe drive. About the only relevant change is that I have forced the Windows caching mode from

Re: [sqlite] Back on-line. Was: Mailing list shutting down...

2018-06-14 Thread Don V Nielsen
> Do we need any further evidence that the heart of man is deceitful above all things, and desperately wicked? Per Keith Metcalf: "The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume." On Thu, Jun 14, 2018 at 12:38 PM R Smith

Re: [sqlite] .timer

2018-06-14 Thread x
Thanks for the replies. It is Windows Defender I’m using on a ms surface pro 4 with 16 GB ram and 512 GB SSD. OS is Windows 10 Pro. I’ve come up with the following demo using the sqlite shell. In it I use a couple of small apps called AvlRAM and FlushMem. Apart from minor background tasks

Re: [sqlite] Mailing list shutting down...

2018-06-14 Thread Ian Zimmerman
On 2018-06-14 17:17, Vincenzo Campanella wrote: > uses googlegroups.com, that then works exactly as a mailing list > (their mail address is wx-us...@googlegroups.com); perhaps this can > give you an alternative idea... It works fine as a mailing list _if_ most (better: all) posters use it as

Re: [sqlite] Back on-line. Was: Mailing list shutting down...

2018-06-14 Thread R Smith
On 2018/06/14 5:58 PM, Richard Hipp wrote: Do we need any further evidence that the heart of man is deceitful above all things, and desperately wicked? That's only the heart of woman... The heart of man is much much worse. ___ sqlite-users

Re: [sqlite] Back on-line. Was: Mailing list shutting down...

2018-06-14 Thread Kevin O'Gorman
On Thu, Jun 14, 2018 at 8:58 AM, Richard Hipp wrote: > ... > > So there you have it: If you want to harass someone by sending them > thousands of subscription confirmations, there is now a website to > assist you. Do we need any further evidence that the heart of man is > deceitful above

Re: [sqlite] .timer

2018-06-14 Thread Warren Young
On Jun 14, 2018, at 11:00 AM, Bob Friesenhahn wrote: > > On Thu, 14 Jun 2018, Warren Young wrote: > >> On Jun 14, 2018, at 8:36 AM, x wrote: >>> >>> It is indeed windows Ryan and at times we’re talking 120 secs versus 30 + >>> 14. >> >> Are you using Windows Defender or some other

Re: [sqlite] .timer

2018-06-14 Thread Bob Friesenhahn
On Thu, 14 Jun 2018, Warren Young wrote: On Jun 14, 2018, at 8:36 AM, x wrote: It is indeed windows Ryan and at times we’re talking 120 secs versus 30 + 14. I can think of two good possibilities: 1. Are you using Windows Defender or some other antimalware solution? If it’s a third-party

Re: [sqlite] .timer

2018-06-14 Thread Warren Young
On Jun 14, 2018, at 8:36 AM, x wrote: > > It is indeed windows Ryan and at times we’re talking 120 secs versus 30 + 14. I can think of two good possibilities: 1. Are you using Windows Defender or some other antimalware solution? If it’s a third-party product, some of those are very

Re: [sqlite] .timer

2018-06-14 Thread Keith Medcalf
Exactly. REAL is the elapsed time according to the wall clock USER is the actual time the CPU spent executing user code SYS is the actual time the CPU spent executing system code In "modern" Operating Systems USER usually reflects CPU usage by your process while the CPU is in USER mode

Re: [sqlite] Back on-line. Was: Mailing list shutting down...

2018-06-14 Thread David Raymond
-Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Thursday, June 14, 2018 11:59 AM To: SQLite mailing list; fossil-users Subject: Re: [sqlite] Back on-line. Was: Mailing list shutting down... So there you have

Re: [sqlite] Back on-line. Was: Mailing list shutting down...

2018-06-14 Thread Richard Hipp
On 6/14/18, Gary R. Schmidt wrote: > > Would you be willing to publish your fix to the mailman list so that > others could make use of it? > I will provide *some* information: I installed a CGI logging system on selected parts of the subscription interface, and I am running "tail -f" on the log

Re: [sqlite] Mailing list shutting down...

2018-06-14 Thread Vincenzo Campanella
Il 13.06.2018 15:28, Olivier Mascia ha scritto: Le 13 juin 2018 à 13:22, Richard Hipp a écrit : Unfortunately, I'm going to need to shut down this mailing list due to robot harassment. ... I have already suspended new subscriptions. Existing subscribers will be able to continue using this

Re: [sqlite] .timer

2018-06-14 Thread Dan Kennedy
On 06/14/2018 03:08 PM, Simon Slavin wrote: On 14 Jun 2018, at 8:33am, x wrote: Could someone describe what the return values real, user and sys mean and why there’s sometimes a big difference between real and the sum of user & sys?. [The following is simplified for clarity.] 'real' --

Re: [sqlite] Back on-line. Was: Mailing list shutting down...

2018-06-14 Thread William.Drago
> Mailing lists are now back on-line and once again accepting subscriptions. I > have implemented measures to block the subscription robots and to better > log subscription activity to better detect future mischief. Thank you. I learn so much from this list. -- Bill Drago Software Engineer L3

Re: [sqlite] Issue with node-sqlite3

2018-06-14 Thread Wout Mertens
Another datapoint: while the sqlite3 module gets only minimal attention, it does work fine and we do use it in production for years now. On Wed, Jun 13, 2018 at 4:26 PM Peter Johnson wrote: > Hi Omer, > > Unfortunately what you are trying to do it not possible. > > You are trying to run the npm

Re: [sqlite] .timer

2018-06-14 Thread x
It is indeed windows Ryan and at times we’re talking 120 secs versus 30 + 14. This is related to the thread http://sqlite.1065341.n5.nabble.com/This-is-driving-me-nuts-td102034.html or at least the latter part of it. I’m currently working on a repeatable shell demonstration to show how bad a

Re: [sqlite] Back on-line. Was: Mailing list shutting down...

2018-06-14 Thread Richard Hipp
On 6/14/18, Gary R. Schmidt wrote: > > Would you be willing to publish your fix to the mailman list so that > others could make use of it? I don't want help the spammers develop work-arounds. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing

Re: [sqlite] Back on-line. Was: Mailing list shutting down...

2018-06-14 Thread Gary R. Schmidt
On 14/06/2018 23:05, Richard Hipp wrote: On 6/13/18, Richard Hipp wrote: Unfortunately, I'm going to need to shut down this mailing list due to robot harassment. I am working to come up with a fix or an alternative now Mailing lists are now back on-line and once again accepting

[sqlite] Back on-line. Was: Mailing list shutting down...

2018-06-14 Thread Richard Hipp
On 6/13/18, Richard Hipp wrote: > Unfortunately, I'm going to need to shut down this mailing list due to > robot harassment. I am working to come up with a fix or an > alternative now Mailing lists are now back on-line and once again accepting subscriptions. I have implemented measures to

[sqlite] VS2003 BUILD BUG

2018-06-14 Thread ????????
BUG VS2003 NOT BUILD sqlite3.obj : error LNK2019: 无法解析的外部符号 __ReadWriteBarrier ,该符号在函数 _sqlite3MemoryBarrier 中被引用 MY FIX OLD // SQLITE_PRIVATE void sqlite3MemoryBarrier(void){ #if defined(SQLITE_MEMORY_BARRIER)

Re: [sqlite] .timer

2018-06-14 Thread R Smith
On 2018/06/14 10:28 AM, x wrote: Thanks for the detail Simon. I’m consistently getting some really big differences where user + sys < real. I’ll post another thread on it but it does seem to be something windows is doing rather than sqlite. If sys + user << real  -  you are probably running

Re: [sqlite] .timer

2018-06-14 Thread Simon Slavin
On 14 Jun 2018, at 9:28am, x wrote: > Thanks for the detail Simon. I’m consistently getting some really big > differences where user + sys < real. I’ll post another thread on it but it > does seem to be something windows is doing rather than sqlite. You're welcome. It's barely worth the post

Re: [sqlite] .timer

2018-06-14 Thread x
Thanks for the detail Simon. I’m consistently getting some really big differences where user + sys < real. I’ll post another thread on it but it does seem to be something windows is doing rather than sqlite. From: sqlite-users on behalf of Simon Slavin

Re: [sqlite] .timer

2018-06-14 Thread Simon Slavin
On 14 Jun 2018, at 8:33am, x wrote: > Could someone describe what the return values real, user and sys mean and why > there’s sometimes a big difference between real and the sum of user & sys?. [The following is simplified for clarity.] 'real' -- Elapsed time between the start and end of the

[sqlite] .timer

2018-06-14 Thread x
Could someone describe what the return values real, user and sys mean and why there’s sometimes a big difference between real and the sum of user & sys?. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org