Re: Postgresql/linux speed + reliability

Any true database server with a well written application will be far more resistant to data corruption than MS Access. This is true as a matter of course due to the data storage format Access uses (whatever it is) and the fact that they don't use transactions. People smarter than me on this list can tell you exactly why, all I know is that I have never had a data corruption problem in PostgreSQL, and I had many in Access.

Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: iharding(at)tpchd(dot)org

>>> Eel <eel(at)javabox(dot)com> 02/15/02 08:24AM >>>
Hans,
Thanks but I'm not sure you understood what I was saying. I'm
considering switching to Postgresql from VB using Access database
which is very unreliable. From what you're saying MS applications can
cause problems that have nothing to do with Postgresql. In that
event, I guess any SQL server with MS clients will have the same
problem. Am I right?

If an MS app crashes, that's one thing. I'm more worried about
what happens to a Postgresql server when it does. Does it corrupt the
database? You're saying MS sends bogus records. I think that would
be an issue with the ODBC driver. Is that very stable? My
architecture allows me to cut MS out out of the loop to a large
extent.

Thanks

Hans-Juergen Schoenig <hs(at)cybertec(dot)at> wrote in message news:<3C6CBDC6(dot)7ACE2341(at)cybertec(dot)at>...
> PostgreSQL is definitely not the problem.
> Also, we did not have troubles with ODBC on PostgreSQL's side.
> The problem is that Microsoft applications seem to be in favour of
> collapsing when sending more than just a few records over an ODBC
> connection.
> I have heard that it works perfectly well for OpenOffice but we had real
> problems with MS products; especially when working with slow connections.
>
> As I always say; the "core" of an MS application is a "dump" ...
>
> Hans
>
> --
> Cybertec Geschwinde &. Schoenig
> Ludo-Hartmannplatz 1/14; A-1160 Wien
> Tel.: +43/1/913 68 09 oder +43/664/233 90 75
> URL: www.cybertec.at oder http://postgres.cybertec.at
>
>
>
> --

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly