Hi,

> Firebird is currently set up in Classic mode and each
> spawned process is taking up around 250-300MB of memory.

That's too much (usually). What's you 'cache pages' setup? For FB classic
usually a cache pages between 75 and 500 is what you need. Be aware to to
use a 'chace pages' setup from SS with Classic.

> My question is this: Do you think that there would be a notable
> performance increase by using Superserver mode rather than Classic?

Yes. SS will be a lot slower (in my experience)

> Also, are there any additional configuration options that I may have
> overlooked that might help with performance?

Run gstat -h yourdatabase.fdb and look for 'page buffers', it should not be
greater than 500. If it's zero, than it's using default configuration inside
firebird.conf -- than, look there.

To setup your custom page buffers for this DB use GFIX, example:

gfix -buffers 150 yourdatabase.fdb


Regards,
Anderson Farias