# Neutron speech

**Introduction (2 minutes)**

Hello everyone! I'm Ales from the bro-n-bro team. Today, I'm excited to share with you the progress we've made since we received the first grant for our Neutron indexer project. Your support has been crucial, and I'm eager to show you what we've accomplished, the latest improvements, and talk about our plans for further collaboration.

**Overview of Achievements and Successes (7 minutes)**

Thanks to your grant, we've significantly enhanced our indexing process. Here's what we've achieved:

- Improved Crawling Process: We revisited our crawling approach, focusing on events and messages, which allowed us to create three main tables: raw_transaction, raw_block, and raw_block_results. These tables can be used to build any data structure, including state data, opening up vast possibilities for data analysis and use.
- Monitoring: [Switch to a live demo] We've implemented a monitoring system to track the performance and stability of our indexer in real time. missed and double data, perfomance.
- Indexing Performance: The indexing speed ranges from 7 to 16 hours depending on the hardware, which translates to about 160 to 370 blocks per second.
- We encountered a minor issue with data consistency due to some transactions getting lost on the API node we're indexing from, but it's not directly related to our product, and we're working on fixing this issue.
- 0.507781 avg 1.275893 max 0.003139 min 12285 blocks [repo]
- swaps same
-

**Indexer Demonstration (10 minutes)**

Let me show you the power and efficiency of our fully functional indexer. [Switch to a live demo]. You will see:

- Raw_tables
- debs_and_creds
- wasm_info
- swaps
- votes

**Upcoming Tasks and User Benefits (5 minutes)**

In the near future, we will focus on the following tasks:

- Bug Hunting: Improving the stability and reliability of our indexer.
- Writing Tables with historical States of Contracts and Astroport Pools: Expanding our database for more detailed and in-depth data analysis.
- Direct Indexing from Storage: Reducing indexing time to just one hour, which will significantly speed up data access.

The benefits of our indexer for users include:

- Out-of-the-Box Functionality: Easy to set up and configure.
- Flexible SQL Table Design: Ability to tailor data structures for specific tasks.
- Support for All Modules: Compatibility with various data types and systems.
- Consistency and Speed: High performance and data accuracy.
- Monitoring: Continuous system health checks."

**Conclusion (2 minutes)**

To wrap up, your support has allowed us to make significant progress, and our indexer is ready for new challenges and opportunities. We remain committed to further improving and expanding our product, and your continued cooperation and support are vital for achieving our shared goals. Thank you for your trust and partnership.

**Q&A Session**

I invite you to ask any questions about our current achievements, future plans, or how we can work together to maximize the impact of our project. Your opinions and suggestions are incredibly valuable.