>>>>
>>>>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.
DUH! Another instance where I should crack the binding on the User's Manual.
Thanks Ed.
Matt McDonnell
...building a better mousetrap with moldy cheese...