Here's the facts:
- MapGuide for the longest time has an FDO provider that can read SQLite databases
- SQLite has an in-memory mode
- :memory: is a completely valid file name to pass to the connection parameters of a SQLite FDO connection
- In terms of I/O, memory is the fastest backing store you can have for direct data access.
Now how can we make MapGuide blazing fast (where it is currently not), given the above facts?
That question has been brewing in my mind for some time now.