Optimize person initials DB lookup

[Petr Nejedly]

It times out with a huge library.

http://forum.serviio.org/viewtopic.php?f=5&t=2277&p=13530#p13530

{{{

2011-04-17 05:44:49,446 DEBUG [ContentDirectory] Browse() called for renderer Samsung DTV DMR (profile 7) with parameters: objectID = A_A, browseFlag = BrowseDirectChildren, filter = @id,@parentID,@restricted,dc:title,upnp:class,res,dc:date,@childCount,sec:CaptionInfo,sec:CaptionInfoEx, sec:dcmInfo, sec:MetaFileInfo,res@resolution,res@size,upnp:genre,dc:date,upnp:album,res@duration,upnp:albumArtURI,res@bitrate,dc:creator, startIndex = 0, count = 20, sortCriteria = 2011-04-17 05:44:49,446 DEBUG [PersonDAOImpl] Retrieving list of person initials (role = ARTIST, from=0, count=20) 2011-04-17 05:44:50,837 DEBUG [PersonDAOImpl] Retrieving number of persons with initial ( and role ARTIST 2011-04-17 05:44:52,181 DEBUG [PersonDAOImpl] Retrieving number of persons with initial . and role ARTIST 2011-04-17 05:44:53,618 DEBUG [PersonDAOImpl] Retrieving number of persons with initial 1 and role ARTIST 2011-04-17 05:44:54,962 DEBUG [PersonDAOImpl] Retrieving number of persons with initial 2 and role ARTIST 2011-04-17 05:44:56,290 DEBUG [PersonDAOImpl] Retrieving number of persons with initial 3 and role ARTIST 2011-04-17 05:44:57,743 DEBUG [PersonDAOImpl] Retrieving number of persons with initial 4 and role ARTIST 2011-04-17 05:44:59,071 DEBUG [PersonDAOImpl] Retrieving number of persons with initial 5 and role ARTIST 2011-04-17 05:45:00,415 DEBUG [PersonDAOImpl] Retrieving number of persons with initial 6 and role ARTIST 2011-04-17 05:45:01,603 DEBUG [RendererManager] Removing renderer b1367d30-ab39-3bc9-6986-32020755930d from list of active renderers 2011-04-17 05:45:01,868 DEBUG [PersonDAOImpl] Retrieving number of persons with initial 7 and role ARTIST 2011-04-17 05:45:03,196 DEBUG [PersonDAOImpl] Retrieving number of persons with initial 8 and role ARTIST 2011-04-17 05:45:04,540 DEBUG [PersonDAOImpl] Retrieving number of persons with initial 9 and role ARTIST 2011-04-17 05:45:05,978 DEBUG [PersonDAOImpl] Retrieving number of persons with initial A and role ARTIST 2011-04-17 05:45:07,337 DEBUG [PersonDAOImpl] Retrieving number of persons with initial B and role ARTIST 2011-04-17 05:45:08,696 DEBUG [PersonDAOImpl] Retrieving number of persons with initial C and role ARTIST 2011-04-17 05:45:10,150 DEBUG [PersonDAOImpl] Retrieving number of persons with initial D and role ARTIST 2011-04-17 05:45:11,493 DEBUG [PersonDAOImpl] Retrieving number of persons with initial E and role ARTIST 2011-04-17 05:45:12,306 DEBUG [DiscoveryAdvertisementNotifier] Multicasting SSDP alive using interface eth0 (NVIDIA nForce Networking Controller) and address 192.168.0.101, timeout = 0 2011-04-17 05:45:12,306 DEBUG [DiscoveryAdvertisementNotifier] Sending 6 'alive' messages describing device 50339d3c-c744-3be9-9a24-dbb8871e1f05 2011-04-17 05:45:12,821 DEBUG [PersonDAOImpl] Retrieving number of persons with initial F and role ARTIST 2011-04-17 05:45:14,259 DEBUG [PersonDAOImpl] Retrieving number of persons with initial G and role ARTIST 2011-04-17 05:45:14,321 DEBUG [DiscoveryAdvertisementNotifier] Will advertise again in 00:01:14 2011-04-17 05:45:15,634 DEBUG [PersonDAOImpl] Retrieving number of persons with initial H and role ARTIST 2011-04-17 05:45:16,978 DEBUG [PersonDAOImpl] Retrieving number of persons with initial I and role ARTIST 2011-04-17 05:45:18,431 DEBUG [PersonDAOImpl] Retrieving number of person initials for role ARTIST }}}