Alexander:

I think that the Database (table) and SQL I am using for 'test' is
causing some confusion. The application we are developing have a
large number of tables and were correctly modeled with all data
structures constructed correctly.
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. What we are trying to do is to get more involved in the
Firebird environment getting knowledge and experiences to lower the
time needed to run the application.
I need to consider to keep using Firebird (or other RDBS) or try to
change for another architecture (technical environment) that could
provide performance and functionallity.
In the beginning we used to develop the applications using flat files
running everything in memory, but for sure using RDBMS could bring
faster development and maintenance, and we would like to keep in this
way (using RDBMS).

Regards, and thank you very much,

Wagner
--- In firebird-support@yahoogroups.com, "Alexander V.Nevsky"
<ded@h...> wrote:

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

wrote:

> > To a final decision about using or not Firebird I prepared a

small

> > application with only one SQL doing a reading in a 140000+

records

> > table. The SQL is very simple:
> > 'select * from palavra where original like '%a' and ordenada not
> > like 'a%' and original=ordenada'
>
> Wagner, I don't believe any RDBMS will show good performance on
> natural scans of large tables. I can suppose
>
> a) your task requires something like web search engine and full-text
> indexed search
> b) you did'nt payed enough attention to model of area of
> automatization and data structures and try to implement search

within

> unordered chars instead of conditions on indexed columns of joined
> tables which reflects entities and relations in real world.
>
> Best regards,
> Alexander.