Re: [pepysdiary] Annotation slowness
- Did what you did help? Alas, not yet.
As Susan has written, your work is not unappreciated (FWIW).
But it is surely aggravating to have the site bite back, as though you had created your own monster!
TerryOn Mon, Jan 16, 2012 at 10:41 AM, Phil Gyford <lists@...> wrote:
Sorry about the slowness.I *might* have done something which will help... Languagehat emailed me while the site wasn't even responding, and I happened to catch it while it was at its worse. There was a single database process that was taking minutes to send all its data, and that was holding up everything else.I eventually worked out that that database query was coming from one of the several anti-spam systems! I've turned it off entirely now. I'm not sure that it's made a difference, and there's at least one other thing making an occasional, very slow database query which I haven't tracked down yet.Let me know if it seems to have helped...PhilOn 16 Jan, 2012, at 09:29, Susan Thomas wrote:
I've turned off the list of recently-annotated diary entries on the Recent Activity page temporarily. This was certainly one cause of slowness. I'll try and find time to find a solution and get it back up again later today.On 17 Jan, 2012, at 01:00, terry foreman wrote: Sorry that this is still missing. The list is generated by a database query that appears to take several minutes to run, blocking everything else in the meantime. I'm trying to find a new way of doing it that doesn't cause this problem.On 17 Jan, 2012, at 12:26, Phil Gyford wrote:
- Thanks for all your hard work, Phil! Much appreciated by us all.On 18 January 2012 19:51, Phil Gyford <lists@...> wrote:
Sorry that this is still missing. The list is generated by a database query that appears to take several minutes to run, blocking everything else in the meantime. I'm trying to find a new way of doing it that doesn't cause this problem.On 17 Jan, 2012, at 12:26, Phil Gyford wrote:--
Level 3 88 Jephson St
Office: +61 7 3503 1765
Mobile: 0411 094 688
Fax: +61 7 3318 7677
Legal Notice: This electronic mail and its attachments are intended solely for the person(s) to whom they are addressed and contain information, which is confidential or otherwise protected from disclosure, except for the purpose for which they are intended. Dissemination, distribution, or reproduction by anyone other than the intended recipients is prohibited and may be illegal. If you are not an intended recipient, please immediately inform the sender and return the electronic mail and its attachments and destroy any copies, which may be in your possession. By reading this communication, the recipient(s) have accepted that it is confidential and NOT subject to any form of public disclosure. Nothing in this communication is intended to operate as an electronic signature under applicable law. The company screens electronic mails for viruses but does not warrant that this electronic mail is free of any viruses. The company accepts no liability for any damage caused by any virus transmitted by this electronic mail.
Sorry that it's still down - I'll have time on Saturday to have a look at it!On 18 Jan, 2012, at 12:09, Susan Thomas wrote: