Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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<<
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only