I'm working on integrating real-time cryptocurrency data into a Big Data Cloud Platform, specifically focusing on Solana blockchain transactions. I noticed a significant performance drop when querying large datasets, with memory leaks and increased processing time. I've tried optimizing database queries, upgrading the cloud service plan, and checking network connectivity, but the issue persists. Any suggestions or lesser-known tricks to resolve this would be greatly appreciated.