For one of our projects we needed to receive, store and display to a UI a large amount of data in realtime. This data is generated by devices located around the world and represented network activity, device location and some other information. Performance was a key key metric for the project. End user should be able to track any device in as close to real time as possible,
The project (where Sphinx applied later) started 2009 had large database of emails , contacts and various business transaction records. It was done with PHP and MySQL. The project had had to be long-standing, and the database was growing fast. After couple years we’ve felt lack of fine full-text search. For that time the MySQL build-in fulltext indexes haven’t been available yet as it was implemented in v5.5. After the quick review of some open source tools for full text search we decided to use the Sphinx.
Network Map performs scanning of network and builds graphical views of discovered network topology. Used tools and technologies: Delphi MS SQL Oracle Newer version screens (also integrated with Inventory project) Database connection settings List of available units – computers with Agents installed on them Detailed information about computer hardware List of SNMP units with possibility… Read More »