Re: [Iodbc-macosx] Performance questions

[Maury M. <mau...@gm...>]

On 2012-04-24, at 5:48 AM, Tim Haynes wrote:

> more obvious things is: if you're using a hostname to access the remote 
> end, does DNS respond rapidly? What if you use its IP# instead?

I am using the IP, sorry :-) Actually that was by accident, it was on the far side of the VPN so I simply pinged it and used that IP.

> If it's quick enough with the db running locally, then it's unlikely to 

Herein lies the rub - the machine in question is locked down tight, and I don't have the admin password. As a result, i can't install *anything* so I haven't been able to set up the ODBC connection. The driver is not visible in the User DSN tab so I'm sunk for now. I'm working on this.

> 850 rows of 20 columns is not huge, unless you've got blobs in there.

char, int and float!

> As a rule, RDMBSs run quickest when you let the engine do most of the 
> computation and just pull back the rows required.

For sure, and in this case even the largest table is perhaps 100 kB of text being sent back.

But it really seems to be that "setup delay". I can see the outbound channel lighting up, but *very* little data going through it.

> to your odbc.ini / $ODBCINI file to show how the application's behaving.

Is there a similar setting on the Mac side? This sounds *very* interesting.