>>>
>>>WOW! You must be running a MONSTER of a network to get that kind of performance. 64-bit maybe? Maybe not.
>>>
>>>Although, on further consideration, I've often found that once the connection is established, ODBC performance is pretty good, even with Sybase. I just wish it didn't take as long to establish a connection, particularly with views. Why don't the views that call the same database use the same connection? I wrote an app last year where I created my own 'views' (which weren't updateable) that all used the same connection in order to improve on connection time. Anyone find a better way?
>>
>>
>>By default, the views do not share the same connection (although they are defined using the same connection!). I had to make sure that all views were marked to share the same connection....
>
>HUH? what do you mean 'marked'? Is there a way to force views to use the same connection? I'm stumped.
Look at Query/Advanced Options menu option in View Designer.
Edward Pikman
Independent Consultant