Have you tried...

....setting the isolation level for all read operations to READ UNCOMMITTED ? That way it's not waiting for any transactions to commit and can help performance tremendously.

I mean, there's no reason to use any higher isolation level with the nature of this application.

Posted By: Steve in Holland on May 9th 2012 at 15:56:27

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.