News/Changes
2010-02-15
Update on the development progress
Finally a new life sign... :)
after a bad start into the new year with a failing harddrive (bad blocks, so
I couldn't start the OS) that slowed me down together with one 66h work week in mid January,
I was finally able to complete some of the work.
The best news is that on Wednesday last week JMDB v1.40 pre1 has been send to some beta users. After I finally have my E-Mail application reinstalled after the harddrive failure, some more testers will get access to the new version shortly. When I don't get seriously bugreports this version will be available shortly to everyone (7-10 days). The only thing I'm going to update are the MovieCollection example files, as pre1 currently contains outdated files.
The enhancements and new features added since December 2009:
- Around Christmas I added the full text search for MySQL and PostgreSQL. At first I
wasn't sure how good the MySQL implementation would work out, because the text
search feature only works with MyISAM but not InnoDB which normally is used and
also supportes transactions. The speed improvement for MySQL and PostgreSQL is
very good but will still improve when I finally complete my backend changes
(connection pooling,...). In case you don't remember the speed improvement for
the plain search here are the old results using (I)LIKE:
- Actor (name) search: 2800-times faster (5.6 sec down to 2.5 msec)
- Movie (title) search: 1000-times faster (15.0 sec down to 15.3 msec)
- The SQL search tab is currently put on hold because of some Java Swing problems I wasn't able to solve yet.
- I cleaned some code parts and added better error handling at several parts of the code
- For other enhancements I made since JMDB v1.36 look in the news of 2009! Most are speed enhancements (import and with the text search also query speed improvments) and some are additional checks for the IMDb errors that showed up a lot last year.
2010-01-02
Happy new year!