We have numerous 24/7 large sites that are using the opensource version
of interbase 6.0.1.6. Our app is written in Delphi 5 using the BDE as
its gateway to interbase.

It is not an option to rewrite our app to use IBO or IBX components so
we will have to stick with the BDE for the time being. However we are
experiencing performance degredation at some of these sites were we have
to either a) backup and restore or b) reboot machine / interbase to get
it performing well again. It appears to be slowing down after a week or
so whereby opening a connection to interbase by using the
TDAtabase.Connected := True can take anywhere upto 10 minutes to
connect, once it has connected the queries run at normal speed in the
app, so it seems that the problem lies with trying to get a connection
from interbase.

My Question is, with my app and current configuration as is, can I
simply install FB and restore a backup of the database and all will
work, will it improve my systems performance ?, will it eradicate this
annoying problem for my sites ?

Any help would be much appreciated as I am at my wits end with this.

Best Regards

Martin Dew

-----Original Message-----
From: Rafael Szuminski [mailto:raf@...]
Sent: 05 November 2003 17:36
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: Distribution question

As far as I understand, the issue is with the security database.
Basically you can only have one security database on your system.
Anybody knows if this change is even planned for 2.0?

Raf


soso_pub wrote:

> Ohh well,
>
> I plan to distribute my app within 3 months or such. Is there any
> chance for this feature to be added until then? :P Ok, for somebody
> who is confortable with FB internals, is it hard/complex/lots of
> dependecies to remove/update the "offending" code to make it work like

> I said? I think I am willing to spend a couple of weeks to make it
> work.
>
> Sorin
>
> --- In firebird-support@yahoogroups.com, Rafael Szuminski <raf@b...>
> wrote:
>
>>Hey, get in line, this feature has been on the wish-list of so many
>
> people for
>
>>so long ;-)
>>
>>raf
>>
>>soso_pub wrote:
>>
>>>Hello all,
>>>
>>>I would like to distribute Firebird (1.0.x or 1.5) with my
>>>application and I would like to automatically install it along with
>>>my
>
> application.
>
>>>The database will be used by my application only so I want to install

>>>it in such a way that it will not affect any existing
>>>Interbase/Firebird installation. Is it possible to do this?
>>>
>>>Thanks in advance,
>>>Sorin
>
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>

--
Rafael Szuminski
Email:raf@...
Phone:(949)939 - 2458
www.BDCSoftware.com



To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/