--- In firebird-support@yahoogroups.com, "shuemiula2" <shuemiula2@...>
wrote:

>
> Hi all,
>
>
> I want to improve following speed.
>
> query per sametime connections on PentiumM 1.6GHz
>
> 1 connection : 143ms
> 3 connections : 355ms
> 100 connections : 1,318ms
>
> tests with JMeter/JDBC
>
> SQL:
> select count(*)
> from tbl_sample;
> # tbl_sample has 50,000 records.
>
> There are good ideas?
>

A laptop will never handle 100 concurrent connections well. For lots
of connections, classic server will use SMP better than Superserver.
(But you have a Pentium M so that is a non issue here)

Count(*) is a slow operation without a where clause. Use exists
instead to check for the existence of a record.

Adam