Subject Re: [ib-support] File system
Author Helen Borrie
At 10:27 AM 24-02-02 +0100, Krzysztof Dyczkowski wrote:

>We made medium-sized application (approx. 600MB-1GB of db file) on INTERBASE
>6.01/LINUX and Delphi 4.0 with DBE. From time to time (eg. once for 2
>weeks) in some our clients we have problem with database file (some data is
>lost, data page errors, index errors). We checked hardware and system many
>times and there we didn't find any problem.
>
>Can it be any problem with BDE? I'm asking because You write something like
>that. If yes it will be terrible because of Thousands line of code, many
>database components....

Yes, it could be; or it could be something else; or a combination of
factors. You would need to supply more details of the problem, not just
symptoms. Interbase.log snippets, numbers of connected users, whether your
IB 6 is classic or superserver (I can't recall whether a SS version of 6.01
was available...), whether your application uses cached updates, schema
caching, how your BDE alias is set up, whether you have data access
components inside the app that connect "directly" (through an implicit
connection, not via a TDatabase), et al.

For now, I should comment that the BDE and native InterBase driver supplied
with Delphi 4 are *very* old. It would be surprising not to encounter some
kind of problem with them, since IB 5.1 was the current IB version when
they were written. I would *not* attempt to write a production application
with the wrong driver support unless my customer were prepared to write a
blank cheque for the inevitable rework that would follow.

Add to that, you are using a rather ancient version of Open Edition IB
6. Have a look at the bug list for Firebird to see the bugs that Firebird
fixed in the Firebird code. The same code - minus a great many of those
fixes - was used to build *your* InterBase binary.

An incorrect BDE setup and/or users crashing out of your application
abnormally is liable to corrupt the client layer at any time but it is
impossible to pinpoint a problem without some clues.

As for your many 1000s of lines of code...surely not every line is related
to data access?

regards,
Helen


All for Open and Open for All
Firebird Open SQL Database ยท http://firebirdsql.org
_______________________________________________________