king arthur Posted July 17, 2006 Share Posted July 17, 2006 When would be appropriate to add the "DELAYED" keyword to an insert? I am writing a traffic analysis system which logs info on every pageload and click thru and info is typically inserted by connecting once, inserting the data with one query, then disconnecting. Part of the info stored is the referrer string, which can be rather long sometimes (regularly over 1000 chars for one particular referrer). How busy would the site need to be to warrant using DELAYED on the inserts? Quote Link to comment https://forums.phpfreaks.com/topic/14838-when-to-use-insert-delayed/ Share on other sites More sharing options...
fenway Posted July 17, 2006 Share Posted July 17, 2006 There is some overhead to using DELAYED, since you're creating a second INSERT queue; however, it becomes much faster for bulk inserts because the client doesn't have to "wait" for the insert to finish before you can move on. In other words, if your don't need to newly created ID back, then you can use delayed without a problem. Quote Link to comment https://forums.phpfreaks.com/topic/14838-when-to-use-insert-delayed/#findComment-59542 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.