Subject RE: [firebird-support] Db performance
Author Alan McDonald
> 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.