Optimizing Social Network Services in Northeast India: Database Indexing and Rate Limiting

In the digital age, social networking services (SNS) have become an integral part of our lives. As more people in Northeast India join these platforms, ensuring their smooth and efficient operation is crucial. This article discusses two key aspects of SNS development: database indexing strategy and rate limiting.

Database Indexing Strategy

The core feature of any SNS is the feed. However, retrieving feed data efficiently is essential to provide a seamless user experience. Without proper indexing, the database would perform a Full Table Scan, checking every single row. To optimize this, a Composite Index was applied.

A Composite Index is a database index that combines two or more columns. In our case, the index consisted of the user_id and created_at columns. By doing so, the database can now jump directly to the user's data and read it sequentially, significantly reducing query time.

Why User_id and Created_at?

The user_id column is used to filter posts by the specific user. The created_at column helps sort them in descending order (latest first).

Protecting the Server: Rate Limiting

To prevent spamming or DDoS-like behavior, it is essential to limit users to a specific number of requests per minute. In this case, the limit was set to 5 requests per minute.

Instead of using heavy external tools like Redis immediately, a lightweight In-Memory Rate Limiter was implemented using Java's ConcurrentHashMap. The rate limiter checks if the count of requests exceeds the limit for each user ID. If it does, the request is blocked.

How it Works?

The rate limiter uses a Map to store the request count for each user ID. A @Scheduled task clears the map every minute.

Frontend Integration (React)

On the frontend, the 429 Too Many Requests error was handled gracefully. If the server rejects a request due to the rate limit, the user sees a friendly alert message instead of a crash.

Implications for Northeast India

As more people in Northeast India join social networking platforms, ensuring their smooth and efficient operation is crucial. The strategies discussed in this article can be applied to improve the performance and stability of SNS in the region, ultimately enhancing user experience.

Conclusion

Backend development is not just about logic but about resource management. Indexes save CPU and I/O, while rate limiters save the server from being overwhelmed. By understanding and implementing these strategies, we can create more efficient and user-friendly social networking services for Northeast India and beyond.