Mohamed Ibrahim’s Blog

Since I updated the website this weekend and it’s been downloading images from MRIS non-stop. In a previous post I said that I had around 900,000 images. I later on discovered that I had dangling images whose listings were deleted. Since this weekend, the update script downloaded almost 820,000 images from MRIS and inserted those binaries inside bytea fields in postgresql. I was expecting things to slow down, however I don’t feel any slow down since the process started. It seems the postgres team really optimized the b-tree indexes to the extreme.

(more…)

A lot of work was done this weekend. Although I refer to it as a lot, yet the amount that is actually reflected on the pages is small. I changed the way mibrahim.net is reading the media from MRIS to a better way, since MRIS update of photo manager.

The old sneeky way that I used was to increment the last digit in the main photo URL. It worked great for most of the listings, and in very rare cases it did not work. After the photo manger update, I noticed that the number of misses started to increase and by further research I found that MRIS now stored more images in the database - i.e. there is no weblink to the media and those images can only be retrieved using a RETS query.

(more…)