>George,
>Thanks for the quick reply.
>>I'd try to limit the amount of data returned...
>How? I don't see a SQLSETPROP argument that, for example, will let me set a max rows returned to 1000. How does the view designer's advanced query option do it? I would assume that we can somehow get to the same OBDC properties, but maybe not.
>
Gary,

It's not in ODBC, but rather in how you specify the retrieval criteria. For example, dividing 4,096 (the packet size) by the record size will tell you how many records can fit in one packet. That's a starting point for your designing the retrieval criteria. You want to limit the number of trips over the wire.

There's no fixed number of records that will guarantee the efficient transmital of the data because of differing record sizes. That's why I mentioned trying to keep the record width as narrow as possible in the design stage, because it will allow more data to be sent than otherwise.