Ahmad wrote:

>>> I need to increase the speed of retreving data in my application, i am
>>> not developer but i know in general about firebird database and server.
>>> i am using firebird server 1.0 but it is soo slow (server action and
>>> local action), if i installed the new version of firebird engin is that will
>>> increase the speed.
>>> please tell me i need to do it quickly, and as i said i am not professional

>> Define "retrieving data". Is that transfering large amounts
>> of records across a network? Running specific queries?
>>
>> What is it that you're trying to do?

> retrieving data i mean Running specific queries across network or
> any action in the application it self (local & on server)even users
> logining
>
> my application built on delphi with GDB firebird, every year it
> becomes slower than the prev. year, these days its boring (slow).

In order to use newer versions of FB, the Delphi application will need to be
rebuilt using newer libraries that can handle FB2. If THAT is not possible,
then the only option is to perhaps remove some legacy data, or alternatively
move the server to a faster computer?

It is unusual for a Firebird application to slow down simply due to amount of
data, so it may be that the original design was poor anyway. My own
applications are faster now despite several years worth of history - simply
because we have moved to faster servers over time.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://home.lsces.co.uk
MEDW - http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Firebird - http://www.firebirdsql.org/index.php