Hi,

> I read in the FAQs that the classic server uses a cache for each
> connection.

Right

> How big is this cache?

cache size (for each connection) = db cache pages * page size

> Is there a default cache size and if so how usefull is it?

there's a default db cache pages. look at DefaultDbCachePages in firebird.conf -- you may also define for each db using 'gfix -buffers'

> In this forum someone posted that on 32 bit windows one must
> rather not use classic.

you probably heard this about new v2.5 SuperClassic, not Classic

> I was just wondering how many connections you can have with
> 1gb memory.

total cache size is :

db cache pages * page size * number of connections

but, you must notice cache is not the only thing it will ocupy memory... there are more to count with

> Is it ok to use classic on a 32 bit windows server if you
> know beforehand that you will only have a small number of users?

Sure

> Apparantly some queries can hog a superserver and then everyone suffers

For SMP machines, Classic is *a lot* better than SS.


Regards,
Anderson