What is Firebird SQL server for?

[denzilla]

Just asking

[Wanderer]

When RC3 creates a new database i.e for MAME, it actually extracts all info about games and their roms from mame.exe itself or from a datafile. It then creates a new local database using the Firebird libraries and saves those info in there.

RC2 directly loaded the datafile in memory, did all the process there and stored all the processed info in a cache file, a process which was complex and needed a lot of memory and cpu power. RC3 uses the database to do all the processing and store all the info. It's faster, more memory-efficient and much easier to use standard SQL commands than caching several custom structures in memory.

[denzilla]

Thanks for the explanation

[RomCenter]

Nothing to add...