Database Software

So, I really like the Oracle Maps API. A lot.

Unfortunately, I don't see a good solution for making it work with datasets that have a large number of layers that can be turned on and off independantly. Because of the number of layers and the fact that the data may change at any time, it's not practical to have base maps cached for each layer. Using an FOI for each layer seem to work well, either.

Anyone tried to address a situation like this yet? To be honest, I'd be happy if I could get the tiles to always generate dynamically with the layers I need- no caching.

It looks like I'll have to go back to using more traditional methods, so I'm just curious how others might be approaching this.