Subject Re: [firebird-support] Performance over VPN
Author Maury Markowitz
On 2012-04-26, at 8:20 AM, Svein Erling Tysvær wrote:

> Exactly what is the definition of your fields?

I can't figure out an easy way to cut-n-paste, but generally there isn't a single column larger than VARCHAR(100). It's an extremely simple database with very little data.

> And what does your select look like (just out of curiosity)?

select * from part - there's about 450 rows and maybe 25 columns of int and varchar

I think the other poster's hit it on the head - if the ODBC interface really does require the client-side to request result sets one row at a time, that is clearly the problem I am facing.