Tuesday 24 November 2009

Timing is Everything

Yesterday's leaden grey skies cleared and woke to more usual tropical paradise weather with clear views from hotel window of dhonis crossing between Male' and airport island.

Fixed more bugs without creating any new ones today.  System almost ready to take to Eyadafushi on Wednesday afternoon.  We've been given a document by unicef describing child protection processes in use or to be implemented (I'm not quite clear which), which lists categories and sub-categories for abuse, delinquency, domestic violence, behaviour,etc.  We have a workshop planned for Wednesday morning with social workers and police to agree on codes to use in the database.  These look like the ones to use.   Then all we have to do is map the 87 codes from the social workers' existing database and an as yet to be determined number of offence codes from the police database to these new ones. 

Malcolm added a logging function to the system so we could accurately measure times for login and to load a case record.  The connection from unicef was very slow this afternoon . For a while I thought the server back in Sheffield that we're running against had died.  The logging software highlighted what I suspected, which was that the addresses table had got so big with the upload of the social workers' data that weprobably shouldn't treat it as a look-up list any more.  We preload the look up data on successful login to the local PC, which saves a lot of data activity everytime we open a screen which references look up data, e.g. in combo boxes.  However, the addresses table now has around 6000 records in it and is likely to double in size when we pull in data from the police database.  We still might preload these data but do so as an asynchronous background activity while the user is viewing their current tasks and reading any new messages (or making a coffee!)

Last night's 7 hours sleep doesn't look like getting repeated tonight.  The aircon in the room is noisily struggling and failing to keep the temperature down. 




Morning rush hour traffic on the way to the airport and Hulhulmale

No comments:

Post a Comment

Note: only a member of this blog may post a comment.