Hey everyone,

I'm currently using OpenDataSoft for managing large datasets, but I'm facing performance bottlenecks on my enterprise server when handling high data loads. I’d love to hear from others who have successfully optimized their setups.

A few questions I have:

1. What server configurations (CPU, RAM, storage) work best for large-scale data processing in OpenDataSoft?
2. Are there caching techniques or database optimizations that improve query speeds?
3. Any recommended load balancing strategies when dealing with heavy API requests?
4. How do you handle real-time data ingestion efficiently?

Looking forward to your insights! Thanks in advance.