Hugh,

I did observe performance degradation with the Linux version of IB 6.0 after
long term use but not the Windows version. Which version are you using?

However, this was no more than slow response time over a network and simply
closing down the server process and restarting it solved the problem. There
was no need to restart Linux.

We have now switched entirely to Firebird 1.02 and have not observed any
performance slow downs since then. I would recommend that you test it out
with a view to upgrading the customers which have a problem.

Regards

Tony Whyman
MWA Software

> -----Original Message-----
> From: Hugh J Borst [mailto:hborst@...]
> Sent: 01 April 2003 22:10
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Re: FB & IB Compatibility / IB 6.0.1.0 problems
>
>
> All;
>
>
>
> Thank you for your efforts. He are a few more details to answer your
> questions, below.
>
>
>
> We have over 200 customers, each with their own server hardware, network
> and IB installation. Each customer has between 10 and 60 concurrent
> users (obviously, this varies widely among customers depending on the
> size of their business).
>
>
>
> The application is written in Delphi with the BDE and does use some of
> the VCL Transaction and IB Transaction components included in Delphi,
> however, I have not as yet familiarized myself with the transaction
> boundary standards that are in use (I've been here for about a month).
>
>
>
> This problem occurs with some regularity, although without any obvious,
> repeatable characteristics (at least, none that have been discovered as
> yet) in terms of some particular transaction or operation. However, in
> all cases, the database and server PC become almost completely
> unresponsive. Backups are not possible. The system will not recover
> until it is rebooted, which, unfortunately, is happening by brute force
> (i.e., RESET BUTTON) at the hands of the customer. When the system
> comes back up, assuming that IB can open the database, oftentimes
> performance is just okay (not great). Once a backup and restore has
> been done on the DB, the system then performs as normal for a while.
> Please note that this is happening for a smallish subset of our
> installed base. We have not as yet been able to identify any universal
> connection among the involved customer installations (other than the IB
> version 6.0.1.0, which is in most all installations).
>
>
>
> I will look into the transaction boundaries for the client application.
>
>
>
> Thanks very much for you assistance.
>
>
>
> Regards,
>
>
>
> Hugh J Borst
>
> hborst@...
>
>
>
>
>
> -----Original Message-----
> From: Aage Johansen [mailto:aagjohan@...]
> Sent: Tuesday, April 01, 2003 1:29 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Re: FB & IB Compatibility
>
>
>
> On Tue, 1 Apr 2003 15:19:34 +0000 (UTC), hugh_borst
> <hborst@...>
> wrote:
>
> > My firm is currently using an Open Source IB extensively across our
> > enterprise. We are concerned about our upgrade path as we do not want
> to
> > incur per server license fees for our product. To this end we are
> > interested in participating in the FireBird project, however, several
> > questions as to compatibility have arisen. If anyone can help answer
> > these Qs, we would very much appreciate the assistance.
>
>
> Hugh, the most important thing now is to sort out the current problems.
> As
> someone said, the problem may well be with the application: a problem
> with
> long running transactions. Check the statistics on the header page
> (gfix
> and IBconsole can show this). If a backup+restore (with gbak) solves
> the
> speed problem (and in particular if the backup is slow), this indicates
> an
> application problem. This may be alleviated, but the apps need fixing.
>
> When you say 200 clients, is this ONE server and 200 clients (or 200
> server
> installations)? If there is one server (or just a few servers) you
> should
> be able to easily upgrade to a later IB (e.g. 6.0.1.6). I would think
> that
> client softare need not be upgraded. A move to Firebird (or later IB
> versions) will need more work.
>
>
> [Others have answered the compatibility Q's]
>
>
> Regards,
> Aage J.
>
>
>
>
>
>
> Yahoo! Groups Sponsor
>
>
>
> ADVERTISEMENT
>
> <http://rd.yahoo.com/M=240537.3105911.4426332.1728375/D=egroupweb/S=1705
> 115386:HM/A=1368546/R=0/*http:/shop.store.yahoo.com/cgi-bin/clink?netfli
> x2+shopping:dmad/M=240537.3105911.4426332.1728375/D=egroupweb/S=17051153
> 86:HM/A=1368546/R=1/1049225336+http://us.rmi.yahoo.com/rmi/http://www.ne
> tflix.com/rmi-framed-url/http://www.netflix.com/Default%3Fmqso=60156051>
>
>
>
>
> <http://us.adserver.yahoo.com/l?M=240537.3105911.4426332.1728375/D=egrou
> pmail/S=:HM/A=1368546/rand=419079821>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo!
> <http://docs.yahoo.com/info/terms/> Terms of Service.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>