Test Results - Resources

["eberhard speer jr." <se...@ducis.net>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

Using the database of resources I have I created XML resources using
the OpenDDR data going back to version 1.12 and up to version 1.18.

I have made those files (DeviceDataSource.xml and
BuilderDataSource.xml) available here :

http://www.ducis.net/static/DataSources.zip

I hope I got the Open Database License details correct in the header,
if not please let me know and I'll correct them accordingly.

If that is OK with everybody I contribute these resource files to the
DeviceMap project (where do I put them ?) and, again if that is OK
with everybody, I will continue to do so with future versions.

Seeing as Werner is the representative of OpenDDR LLC, I'm sure we
would all appreciate it very much if he were so kind as to inform us
about the situation with regard to the future updates of the OpenDDR
resources.

In the meantime : this version of the resources performs slightly
better than the current 1.18 version, using the same test-data set :

1,316 : DeviceMapClient says "desktopDevice", OpenDDR has a DeviceId
  600 : DeviceMapClient says "unknown", OpenDDR has a DeviceId

While it obviously takes a bit longer to load these resources given
their size, the DeviceMapClient's performance is also improved if ever
so slightly -- 3rd decimal digit range. I'm thinking that is due to
order in which the SQL queries return the data (BuilderDataSource :
1st TwostepBuilder ordered by Device, then other builders ORDER BY
LEN(Token) DESC, Token ASC) and maybe we can squeeze a bit more in
that area.

Finally, another nice thing about the new DeviceMapClient, apart from
the *massive* performance improvement, is the fact that it's
performance is pretty consistent compared to the 'old' resolvers.

esjr

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (MingW32)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBAgAGBQJR0HsXAAoJEOxywXcFLKYc63EIAMGG2nDfecK4gXbpunTPbWPI
WpiXqKi/0/AkKTQUaL12alCG7d32/9jLxe6ovaWfyBFQtL1nxurzmMumT4Vto9qk
x6dzfZaXJUPSUh0nodReOFTfmrVWxmrfkfEvpb2BuiYUFzCsQHDPZ9ymAcKuKlmu
t4mxUoJfNTMp2Q0Eo5DrTEkK5GQTpQrxS62OaSI/BoZ0Kbobvj8NgFTso620J2tC
UShCIAD57yKSM6KYNgrYJg/neuHc32Glu/am+BqnDMTMAQewxyE5U79c+gpWuJoH
AmNAFLMXz7UtVpuYfzl52Ol3RUeyUT8mOWXGZgLh+rGaro0O0LcfmdxxxuhLT3M=
=Q5Ju
-----END PGP SIGNATURE-----