Re: Dual Database Connections for Security and Performance

Posted by BJ Freeman on Oct 07, 2006; 8:01pm
URL: http://ofbiz.116.s1.nabble.com/Dual-Database-Connections-for-Security-and-Performance-tp173081p173082.html

this would be a individual setup.
I don't believe every DB have all these capabilities.
Also since most transaction require r/w only views could be used in read
only. this means changing a lot of code, I think.


Daniel Kunkel sent the following on 10/7/2006 10:08 AM:

> Hi
>
> I was doing some research the other day, and heard a rather interesting
> idea that has me wondering.
>
> The suggestion was for all web applications to open two database
> connections, one as read-only, and one with all the normal permissions.
>
> The reader was purported to be faster as well as being automatically
> protected from all sql injections because of its limited read-only
> privileges.
>
> In addition, this reader could be later assigned to a replicated read
> only database in clustered applications which would greatly improve
> overall performance.
>
> I don't know which connection would be better to use with transactional
> queries.
>
> A link that discusses the small performance improvement in a non-
> replicated situation that was observed in an Oracle database.
>
> http://www.dba-
> oracle.com/oracle_tips_read_only_tablespace_performance.htm
>
> Is this a worthwhile idea?
>
> Thanks
>