Posted by
Daniel Kunkel on
Oct 07, 2006; 6:08pm
URL: http://ofbiz.116.s1.nabble.com/Dual-Database-Connections-for-Security-and-Performance-tp173081.html
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
--
Daniel
*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-
Have a GREAT Day!
Daniel Kunkel
[hidden email]
BioWaves, LLC
http://www.BioWaves.com14150 NE 20th St. Suite F1
Bellevue, WA 98007
800-734-3588 425-895-0050
http://www.Apartment-Pets.com http://www.SatelliteRadioZone.comhttp://www.Cards-Visa.com http://www.ColorGlasses.com*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-