Re: ODBC Compression??

    Your best bet is to do compression on the WAN link. I.e. enable compression on the WAN router/interface. That way it's totally transparent, and benefits all WAN apps. Our 64K frame network is configured that way and works well, though we don't do ODBC over the WAN.

Mike Leydon wrote:

> Hi,
>
> Not sure if this is the right place to ask, but here goes...
>
> I am involved in a project that involves integrating some commercial
> products that operate over both a LAN and a WAN.
>
> Oracle ODBC is used as the connection from the clients (running Win95)
> to the server (a Sun E4500, Solaris 2.6, Oracle 7.3.4).
>
> The database is expected to get to around 30GB initially when we have
> finished, growing by around 30GB per year.
>
> Everything works okay, but performance over the WAN is pretty slow
> (links are 64k and up). Like most applications, you tend to make short
> queries and then get (most times) lots of data back.
>
> What I am looking at is some sort of compression to compress the data
> (either one way, or both).
>
> As the products are commercial so I can't get 'into' them, I am
> thinking of putting in a replacement ODBC Driver at the client end,
> along with a matching Listener process at the server end, that
> performs compression of the data.
>
> My question is - is this feasible? Is there someone that has already
> done this, and is it available for use (commercial products not a
> problem)? Or is this just a pipe dream?
>
> Any suggestions welcome...
>
> Regards,
>
> Mike Leydon.
>
> --
> Mike Leydon.
> Melbourne, Australia.
> Delete _NO_CRAP_ for valid email address
Received on Tue Jun 22 1999 - 13:21:42 CDT