+ Post New Thread
Results 1 to 2 of 2
MIS Systems Thread, CMIS Student Groups Slow? in Technical; Queries involving student groups might be slow when the STUGROUPS table is involved. This is because SERCO developers seem to ...
  1. #1


    Join Date
    May 2009
    Posts
    3,202
    Thank Post
    284
    Thanked 862 Times in 645 Posts
    Rep Power
    336

    CMIS Student Groups Slow?

    Queries involving student groups might be slow when the STUGROUPS table is involved. This is because SERCO developers seem to see no need to have as part of an index the field GROUPID, despite this being a necessary key when finding details which include teachers (TEACHINGROUPS). Creating an index with SetID and GroupID will significantly speed up any such queries (and will have a positive impact on the overall performance of the database).

    I'm really posting this for my own future benefit.

  2. #2


    Join Date
    May 2009
    Posts
    3,202
    Thank Post
    284
    Thanked 862 Times in 645 Posts
    Rep Power
    336
    Neg rep!

    It's reasonably useful information for anyone running CMIS. The lack of the index places an un-necessary strain on the database, forcing full table scans where an index scan would do. Without an index, on our database a query was taking a few minutes, with the index, it's almost instant (a second or so). A decent database engine will force transactional consistency on a query (the result will be consistent with the database state at the beginning of the transaction, regardless of any updates which take place during the query). That makes it highly desirable to complete queries quickly.

    I marked this as being for future use as I'd previously found this issue but forgotten exactly which table it applied to. I hope to save myself time in the future but it just might benefit others here. Neg rep for that. Whoever you are, you need to get a life.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 4
    Last Post: 17th July 2012, 09:24 AM
  2. Replies: 1
    Last Post: 27th February 2012, 11:44 AM
  3. Group Policy, Slow Applying GP to clients
    By jman167 in forum Wireless Networks
    Replies: 1
    Last Post: 10th September 2007, 09:57 AM
  4. Group Policy guidelines needed for students in years 3 - 6
    By richard in forum Wireless Networks
    Replies: 6
    Last Post: 8th March 2007, 01:36 PM
  5. Slow group policy
    By molesm in forum Windows
    Replies: 5
    Last Post: 22nd January 2007, 09:23 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •