Re: WHat do people think about using in production?

I couldn't re-produce my problem in testing either, just in production.

I was unable to really hammer the new driver as my current test equipment is
a 650meg XP box with our mail and monitoring software running as well
against a 650 meg fedora core 3 database box (think this could of handled
more, problem was in the front end IIS).

I was able to get 4 concurrent users testing without a loss of memory or any
errors reported.

I am going to give it a try (let me know when the latest and greatest are in
CVS so I can do a test build of what I will plan to go live with).

Worst case is I convert and it blows up bad like last time, best case is it
stays afloat. I am currently having my IIS boxes crash any where from a few
hours to a few days (just can not seem to nail down the cause, I could try
turning on logs since Dave figured out I did not have permissions correct to
write to c drive and see if it crashes, but I am fearful of the amount of
log files and slow down).

Joel Fradkin

Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel. 941-753-7111 ext 305

jfradkin(at)wazagua(dot)com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
This email message is for the use of the intended recipient(s) and may
contain confidential and privileged information. Any unauthorized review,
use, disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete and destroy
all copies of the original message, including attachments.

-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Dave Page
Sent: Tuesday, July 26, 2005 8:47 AM
To: Merlin Moncure; Joel Fradkin
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] WHat do people think about using in production?

_____

From: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Merlin Moncure
Sent: 26 July 2005 13:24
To: Joel Fradkin
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] WHat do people think about using in production?

My personal opinion is that atm the libpq driver is already as good as or
better than the pre-libpq driver. There may be a few as of yet undiscovered
reliability issues or busted features, so there is some risk with the
switchover. Since Dave fixed the excel bug, today I'm going to switch over
my application stack to the new driver and give a more qualitative analysis.

Somewhat unintentionally I should add - it started working after what I
believed were unrelated fixes :-)

Since the new driver is a much better design, (and supports the level 3
protocol!) it will only get better. I think that you can also give some
really good feedback about utf-8 capabilities of the driver (expect some
problems here). I hate to suggest new technology to bail you out of a nasty
situation but ISTM this is the only situation with a high chance of long
term success. The only other option I see is to build a stronger test suite
and hang back for a bit and closely monitor progress.

I agree - the new driver does seem to be at least as good. There are some
more improvements in CVS that haven't made the snapshots yet that you might
want to wait for - specifically, backend error messages are reported
properly now, rather than a default message being issued, a few leaks and
other minor issues have been solved, and SSL support has been added (not
that I expect Joel will want to use that).

How heavily have you load tested the new driver?

I've hammered it with ODBCBench, and a simple IIS app thrashed with
ApacheBench. I've not made it crash yet :-) (but then I couldn't reproduce
Joel's problems with the older driver).

Regards, Dave.