Hi,
if you need fastest natural scan operations for big tables,
you should reduce physical DISK IO operations.
Format your disk with 16K clusters and
use 16K PAGE_SIZE database file on it.
your query operation will need much less cluster access.
as you now, each access needs approximately 10ms for waiting disk.
use Superserver (shared cache) and 8192 cachepages.

Regards.

Ali

--- In firebird-support@yahoogroups.com, "bazarin" <wagner@b...>
wrote:

> Hi:
>
> We need to develop an application to be distributed in a local
> network for near 100 users. We had had some problems with

Interbase
If you need further information I can provide for sure.
...

>
> Regards
>
> Wagner Bazarin
> Mac-Penn
> Sao Paulo
> Brazil