UNIDAC problem FIREBIRD and INTEGER

[sisanat30]

HI.

We have a problem with Firebird and UniDAC components.
Treatment times are very long if we use an integer field.

Configuration :
Firebird : v2.5
UniDAC : v6.1.3
Delphi : v2009

For testing , we have a test machine connected to network whose flow has been deliberately reduced to 128K.

Code: Select all

CREATE TABLE TEST (
    ROW1  VARCHAR(255),
    ROW2  INTEGER
);

INSERT INTO TEST (ROW1, ROW2) VALUES ('value1', 1);
INSERT INTO TEST (ROW1, ROW2) VALUES ('value2', 2);
INSERT INTO TEST (ROW1, ROW2) VALUES ('value3', 3);
INSERT INTO TEST (ROW1, ROW2) VALUES ('value4', 4);
.....

Our Delphi source uses :
- A datamodule with a TUniConnection
- A main.pas with a TUNIQuery.

When we execute the script:

Code: Select all

SELECT ROW1 FROM TEST

We have no problem

But when we execute the script:

Code: Select all

SELECT ROW2 FROM TEST

Treatment times are very long (approximately 6 times longer !!!).

Do you have an idea of where the problem could come from ?
This causes excessively long processing times for our customers.

Regards.

[ViktorV]

Unfortunately, we couldn't reproduce the problem in the way you have described. We got opposite result: it took less time for processing INTEGER fields query than VARCHAR fields. Please send a small sample demonstrating the problem to viktorv*devart*com, including the script for filling in the database objects.

[sisanat30]

Thanks for your response.

It seems that the problem comes from Firebird.
We could reproduce the problem under Ibexpert.

The request result is quick but it takes 4 seconds to "give us the hand".

What version of Firebird do you use ?

[ViktorV]

We used Firebird version 2.5.4.26856 for testing.