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 ...
11th September 2012, 04:50 PM #1
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.
11th September 2012, 07:00 PM #2
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.
By J_Worth in forum Windows Server 2008 R2
Last Post: 17th July 2012, 10:24 AM
By ronnoco in forum Home Access Plus+
Last Post: 27th February 2012, 12:44 PM
By jman167 in forum Wireless Networks
Last Post: 10th September 2007, 10:57 AM
By richard in forum Wireless Networks
Last Post: 8th March 2007, 02:36 PM
By molesm in forum Windows
Last Post: 22nd January 2007, 10:23 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)