For Dodi really (just lazy here)...
Maybe thread
Re: Making database readonly Thread #
649739 Message #
649916> offers something here. Mind you, I didn't read the whole thread.
again, good luck Dodi.
It takes lots of users, but eventually yes. Every view record is locked each time a user runs a query. It seems though that the lock is held while the query string itself is extracted, not for the duration of running the query itself.
>
>>Great idea... I'm going to give it a try...
>>
>>Nope, my old app did not use a DBC. Multiple users accessing DBC slows it down?
>>
>>>SQL Server can be better, but I don't think it necessary here. You create your table tabledbc.DBC and store it on the server.
>>>
>>>The views.DBC contains views like this...
>>>
>>>create sql view someview as ;
>>>select field1, field2 ;
>>>from ;
>>>tabledbc!table1
>>>
>>>etc.
>>>
>>>Your old app didn't use a DBC right?
>>>
>>>>snipped<<