I implemented a mysql based user tracker. On every visit of a user I log some data to the DB. Experimenting with INSERTs I used DELAYED and benchmarked the page. An DELAYED insert takes aprox. 9 times more to execute than an insert. I am using PHP. When I call the query function it takes 9 times more to respond when using a delayed insert than a normal one. I know that the delayed insert will not get really inserted until some conditions are met, but howcome the call takes more time ? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
