Issues

ZF-3107: Use INSERT DELAYED for Zend_Log_Writer_Db

Issue Type: Improvement Created: 2008-04-13T02:24:52.000+0000 Last Updated: 2011-03-23T18:01:32.000+0000 Status: Postponed Fix version(s): Reporter: Nils Caspar (pencil) Assignee: Ralph Schindler (ralph) Tags: - Zend_Log

Related issues: - ZF-9484

Attachments: - ZF-3107_ZF-7149_ZF-9484.patch

Description

{quote} The DELAYED option for the INSERT statement is a MySQL extension to standard SQL that is very useful if you have clients that cannot or need not wait for the INSERT to complete. This is a common situation when you use MySQL for logging (...) {quote}

Using INSERT DELAYED would improve the speed of Zend_Log_Writer_Db. But you can't check, if the INSERT was successful. So maybe it should be an optional feature.

Comments

Posted by Nils Caspar (pencil) on 2008-11-29T13:55:13.000+0000

Yes, No, Maybe..?

Posted by Wil Sinclair (wil) on 2009-01-21T14:39:29.000+0000

We'll consider this for 1.8. For now I am marking it postponed, which indicates that the feature request is sound, but we won't work on it immediately. Have you considered submitting a patch and a corresponding unit test to get it on to trunk sooner? Since it adds a few feature, we will have to wait for the next minor release (1.8).

Posted by Benjamin Eberlei (beberlei) on 2009-01-21T14:45:58.000+0000

one has to check for the mysql adapters when this is a mysql only option, which makes it somewhat more compliacated, otherwise it sounds like a good optimization.

Posted by Thomas Weidner (thomas) on 2010-03-21T10:20:05.000+0000

Reassigning to component lead

Posted by Kamil Dziedzic (arvenil) on 2011-03-06T17:21:58.000+0000

Here is a patch to resolve this issue and #ZF-9484. If you don't like it please write what's wrong with it so I could fix it.

http://kamil.klecza.pl/zend/ZF-3107_ZF-9484.patch/

Posted by Benoît Durand (intiilapa) on 2011-03-13T14:40:56.000+0000

@Kamil, you must first sign the CLA in order to use your patch.

Posted by Kamil Dziedzic (arvenil) on 2011-03-22T23:35:36.000+0000

Hello again. I've signed CLA and here is updated patch to ZF 1.11.4 and now it also includes changes to one more similar ticket #ZF-7149.

http://framework.zend.com/issues/secure/…

I'm waiting for comments.

Posted by Benoît Durand (intiilapa) on 2011-03-23T18:01:32.000+0000

Reassign to the maintener of Zend_Db (Ralph)

Have you found an issue?

See the Overview section for more details.

Copyright

© 2006-2016 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.

Contacts