Re: Re (tilly) 1: Using hashes instead of arrays with database results

True story. A database loading script for Sybase I was working on slowed massively. The problem? The rows got too big for the packets, and passing data slowed massively.

I'm sure you know this - but you can configure the Sybase database server to handle larger packets (up to 8k, I think), and then the client apps can use this as well (I think DBD::Sybase can do this - if not I'll have to add it in!).
It's a potentially huge performance increase for certain types of applications...

Michael

Comment on Re: Re (tilly) 1: Using hashes instead of arrays with database results

Replies are listed 'Best First'.
Re (tilly) 3: Using hashes instead of arrays with database results by tilly (Archbishop) on Jan 31, 2002 at 17:15 UTC
Thanks, I did know that. The setting in DBD::Sybase is already there, it is called packetSize. Doesn't help if your OS setting don't support it, or if you don't control the database...	[reply]