>Hi all,
>I'm trying to find out how to set the max records for an ODBC connection. I assume since it's setable for a remote view, it has to be able to be set for SQL pass through. Any suggestions?
>
Gary,

I'd try to limit the size of the result set based on how many trips back and forth to the server is required. SQL Server for example use an 8K data page. Normally, the default packet size is 4K. Depending on the requirements, I'd try to limit the amount of data returned so that it's between 4 and 8K. This would mean two trips to the backend at most.

The table design process should take this into account. For example, don't use a DateTime data type if a SmallDateTime will meet your needs. Being careful in this aspect will reduce the width of each row along more data to fit into a smaller space.