EVE Technology Lab

Hey Folks,

in the past few week/month i have build an little Application for 'live' analytics on kill/losses from zkillboard.

you can query on the main page general statistics on the kills like the isk value (avg,max,sum). The top 10 used ships (losses or attackers) and also the same grouped by inventory type.

via overview you can filter for an alliance, corp or character and look after his stats for an time periode.

If the box will not update there 2 possilbe errors on my side:

1.) No killmails are found. (error not catched yet )
2.) I'm out of memory on the Database server

Tec bla
The site base on AngularJS, not really structued - most of the time the ajax request a fired after page rendering. In the Backend are 2 Java EE Applications for leeching the kills from Zkillboard an one for deliviering the data to the GUI. As 'Database' is elasticsearch in charge. I know ES is no real No-SQL Database more an search engine.

Every killmail is an little bit adjusted for better query. Non of the Query on the page are cached.

Technical Stats:
- 13,8 million killmails
- 390 million json documents
- 74 GB raw data on the disk (SSD)
- 12 GB field data for statistics in ram
- 28 GB total ram useage


Currently i'm hitting with the database server my resources limit so i must check my options for getting more ram.

So please be not to angry if some things are not working. :)

The link -> EVE-Stats.net

Sofar
Javani