> Hi.
>
> I'm running database with ca 10M records in address book table and up to
> 30 concurrent connections. The server is FB 1.5.2 SuperServer on P4HT
> machine with 1,5GB RAM.
> It's extremely slow by now, and consumes almost 50% of CPU (100% of one
> virtual processor).
> And TaskManager shows, that it allocates only about 10MB of memory.
>
> Should I in this case switch to ClassicServer?
>
> What buffers should I increase to force it to use more memory?
>
> Regards,
>
> Marek Konitz

i'd be looking at my indexes first. check your plans for your queries.
Have you created indexes on lookup fields? it shopuldn't be slow at all.
Alan