"We dug through the code and found there was a hardcoded limit on the wallet file size of 1 GB, inherited from Monero."
I'm not an expert by any means so I might missed something and my thought is nonsense but this must have to do something with the fact that ETN has a huge supply so tx sizes should be also considerably bigger, right? We don't hear about such problems with Monero and Dero's total supply is the same. So I guess this must be another fail of ETN devs' quick copy&paste job lol. Correct me if I'm wrong.
You identified the part that I figured would most apply to DERO - a hard-coded limit on the wallet file size that is intended to prevent overly-long times in loading the file and executing transactions, etc., on it.
However, eventually ANY wallet.dat file will grow beyond reason given enough activity/use if there isn't some means of archiving old transactions. I felt that pointing out the issue with ETN/Cryptopia might give the DERO devs a head-start on dealing with the problem before it becomes a problem, so to speak.
Thanks for info.
we have already created new wallet database design from scratch to handle millions of transactions for exchanges and traders. We also kept in mind low ram consumption, database atomicity, minimum loss in case of server crash/power-loss. Anyone is welcome to test-run latest alpha release wallet for above.