Google Isolation Level. Basically the default is

READ COMMITTED.

That means if it is executing an UPDATE, DELETE or INSERT (or SELECT INTO etc) on a table you attempt to query at the same time, the query needs to wait until all the transactions are committed before being executed (called a read lock). All subsequent read queries will queue behind that one, which of course can escalate to extent, page or even table locks.

That is important for some applications where accurate data is critical. If an application is making an update to a table you don't want to view the new data until the transaction has completed successfully. However, with the Wrath it doesn't matter since the posting method is just fire and forget.

If you SET TRANSACTION_ISOLATION_LEVEL READ UNCOMMITTED (or whatever the MySQL syntax is - I am more a SQL Server man myself) then your queries will simply query the data in the tables whether it is committed or not.

This means that if you are manipulating data in a table and querying it at the same time, the read queries will not wait for any transactions to commit so you get NO locks at all, avoiding escalating row level locks as well.

Then do a smell up the USB.

Innit.

Posted By: Steve in Holland on May 9th 2012 at 16:21:50

Message Thread

Whatever happens to Roth... (General Chat) - yellowman, May 9, 14:48:27
- I love the Mighty Wrath (General Chat) - dr fanta, May 9, 16:02:44
- Should be red (General Chat) - Waddockhunt, May 9, 15:39:34
- Wraths going nowhere (General Chat) - Charles21, May 9, 15:18:45
  - To be fair his plan worked to perfection (n/m) (General Chat) - norway, May 9, 15:42:43
    - agreed, brought all the worms out of the woodwork (General Chat) - Charles21, May 9, 15:55:35
      - No (General Chat) - norway, May 9, 15:56:40
        
        lol (n/m) (General Chat) - Charles21, May 9, 16:11:21
  - I quite like some of the ideas on that Chelsea forum... (General Chat) - Ben, May 9, 15:31:20
    - Indeed - and before you wind up this wrath (General Chat) - norway, May 9, 15:48:24
      - I already know every IP address and have other ways to track multiple users on the same.. (General Chat) - Ben, May 9, 15:53:14
        
        Did Colney Gaz ever come back? (n/m) (General Chat) - Huge Small, May 9, 16:02:07
        
        That would require writing some queries so it will have to wait:) (n/m) (General Chat) - Ben, May 9, 16:10:24
        
        The day of revelation will one day be upon us (General Chat) - norway, May 9, 16:14:58
        
        He who protesteths the most (General Chat) - Charles21, May 9, 16:16:39
        
        No (General Chat) - norway, May 9, 16:39:10
        
        You will all bow down to the almighty Bunghole ! (n/m) (General Chat) - Huge Small, May 9, 16:19:24
        
        ITS THE BELOVED!! (n/m) (General Chat) - Charles21, May 9, 16:27:29
        
        Excellent! (n/m) (General Chat) - norway, May 9, 15:55:49
    - Love it personally (n/m) (General Chat) - Charles21, May 9, 15:37:26
      - ROLF There's a wind up merchant on there called (General Chat) - norway, May 9, 15:45:40
        
        rumbled (n/m) (General Chat) - SCC 28, May 9, 17:45:46
        
        would explain him being here a bit less. Trolling is (General Chat) - Pixelman, May 9, 16:03:47
        
        i think he was posting on a Brighton forum too (General Chat) - Ralf Scrampton, May 9, 16:12:49
        
        I thought it was someone from off of on here at first (General Chat) - Karnivore, May 9, 16:10:59
    - It took some bedding in, to be honest but runs smoothly enough now (General Chat) - Karnivore, May 9, 15:37:02
  - classic Yellalee, biggest stirrer on here .. (n/m) (General Chat) - Only1Doherty, May 9, 15:24:50
    - very much this (General Chat) - SCC 28, May 9, 17:52:28
      - agreed (n/m) (General Chat) - Yellalee, May 9, 18:00:39
- Agreed. Not seen this layout elsewhere and really like it (General Chat) - CityForLife, May 9, 15:07:57
  - The mobile version could do with some work (General Chat) - Ben, May 9, 15:19:51
    - Needs some way of telling how many unread messages are in the tree... (General Chat) - Brom, May 9, 15:27:24
      - Well it seems to work in all the mobiles I've tried over the years (General Chat) - Ben, May 9, 15:32:59
        
        Ben, i have a HTC One X too, and mobile wrath works a treat (General Chat) - city_lad, May 9, 17:16:48
        
        I would need a thumb extension to use it regularly (General Chat) - Ben, May 9, 18:13:23
        
        To be honest Ben I'd just like to see the ignore filter work server side instead of (General Chat) - Steve in Holland, May 9, 15:36:17
        
        English only please (General Chat) - Charles21, May 9, 15:50:12
        
        I think the reason was for performance (General Chat) - Ben, May 9, 15:50:10
        
        Yeah. I suppose you are using MySQL ? Shame it doesn't support materialised views (n/m) (General Chat) - Steve in Holland, May 9, 15:54:09
        
        shame. (General Chat) - Pixelman, May 9, 16:05:29
        
        Have you tried... (General Chat) - Steve in Holland, May 9, 15:56:27
        
        It is using MySQL (General Chat) - Ben, May 9, 16:08:56
        
        Google Isolation Level. Basically the default is (General Chat) - Steve in Holland, May 9, 16:21:50
        
        Daft pot-head. (n/m) (General Chat) - tudders, May 9, 16:00:47
        
        In the trade that's known as doing a smell up the USB (n/m) (General Chat) - Steve in Holland, May 9, 16:06:19

Reply to Message

In order to add a post to the WotB Message Board you must be a registered WotB user.

If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.