Adapter Read Only?

Posts   
 
    
ianvink
User
Posts: 394
Joined: 15-Dec-2006
# Posted on: 16-Nov-2009 19:54:03   

Is there a way to make the adapter only work in a ready only mode, perhaps in the connection string, for the Access DQE?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 17-Nov-2009 02:54:36   

AFAIK no. Please elaborate more why you want such thing.

David Elizondo | LLBLGen Support Team
ianvink
User
Posts: 394
Joined: 15-Dec-2006
# Posted on: 17-Nov-2009 13:11:54   

I have the difficult task of creating a web-app based on Access and I thought since I am executing read-only commands telling the Adapter that it will never write might lighten the load?

SQL Server would be better , but I am limited to Access only.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39862
Joined: 17-Aug-2003
# Posted on: 17-Nov-2009 17:03:32   

What do you mean exactly with 'lighten the load' ? The adapter just creates a connection and fetches, it doesn't open transactions for fetching if you don't ask it to so if you don't save anything, nothing is different from what a readonly adapter would look like. The rest is just code and that doesn't affect performance.

Frans Bouma | Lead developer LLBLGen Pro