Hi,

Can you run these statements and try the query again?


CREATE ASC INDEX I_PALAVRA_1 ON PALAVRA (ORIGINAL);

CREATE ASC INDEX I_PALAVRA_2 ON PALAVRA (ORDENADA);

>
> We need to develop an application to be distributed in a local
> network for near 100 users. We had had some problems with Interbase
> and/or Firebird related with performance, and I am trying to define
> to use Firebird or to quit and try to go into another direction.
> The application to be developed has a very intensive Database usage
> due to each user insert some parameters (like a simulation) and the
> application do a lot of calculation inside the database recording a
> final report to be analysed by the user.
> 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'
> palavra is the table and original/ordenada string fields.
> The test application just ask for the database reading for
> letters 'a' to 'z'. I am using only two units in the same application
> expecting getting good results and extending the test to a multi-
> layer environment (I think using COM+) later.
> Running the application with only one user I got near 10 seconds to
> read all the queries. Running with two users the processing time
> expands to 20 seconds, with three users to 30 seconds and so on.
> Considering that this is a test and that the current test could last
> 2 minutes I will need 200 minutes for the 100 users that will be not
> acceptable.
> Can someone help me on this, giving me some clues and advices? I am
> including the two test units in this text so you can see what I am
> doing (Rigth or wrong).
>

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com