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

> Alexander:
>
> I think that the Database (table) and SQL I am using for 'test' is
> causing some confusion.

Obviously.

> The main problem is that one user do not act as a webuser, but fill
> in some parameters in one of the database table and start the
> application processing. This processing get all parameters provided
> by the users and run a lot of sqls in all tables of the database
> doing some calculations and searchs (normarlly in numbers columns).
> We could run the application in 2.5 minutes (180 seconds), but when
> running for 4 users it last 9/10 minutes (600 seconds), and we need
> to run it for 100 users. Considering the timeframe we got until now
> the application will need 60000 minutes to run what will be
> annaceptable.

The best will be to perform tests on your application itself. Dumb
natural scan and complex searches and calculations are very different
beasts. During tests you should determine what kind of resource is
critical for your application. But in general, if 2.5 minutes for
request is really conditioned by sense of your task and not bad index
usage in queries, and your application seldom modifies data and mainly
selects, seems you really need SMP machine, RAID, 2-4 Gb RAM, Classic
server and 1024-2048 cache buffers per user.

Best regards,
Alexander.