David,

> Hi, all. I am running some performance tests against Firebird, and to
> be honest, it really stinks. For a single client I am getting only
> around 10 TPS. I am sure I must be doing something wrong.

I'm also sure something is wrong. Let's start with the basics:

- what FB version are you running?

- What platform?

- What connection/access method?
- Local
- local loopback TCP
- Remote TCP
- Remote NetBEUI

- what is the nature of the transactions/operations you are performing?
- how many rows are in the tables which are being updated?
- how many rows are being affected?
- how many indexes?
- how selective are the indexes?

- are you using prepared statements/queries?


Sean