Hi Carlos, On 26 March 2013 19:31, Carlos D'Agostino <[email protected]>wrote:
> If I could suggest a small change in order to make a better index on that > table. I made a similar table at one point, but for faster lookups I… (I > know I'm about to be butchered)… I hashed the UA string…. using md5 no > less, but I must say that +500K devices later I haven't had a single > problem. Also, it would be a good idea to add a column that points to the > device's information source (in my case it was WURFL/UAProf). > Would you be willing to contribute your table design? You could create an issue at https://issues.apache.org/jira/browse/DMAP with a .sql file attached, which would give Reza a starting point. It would also be useful to know it's been stress-tested at 500k+ devices! Thanks, Andrew. -- [email protected] / [email protected] http://www.andrewsavory.com/
