AEM 6.3 database Interaction (pros and cons) | Community
Skip to main content
mohanganesh
mohanganesh
Level 2
February 5, 2018
Solved

AEM 6.3 database Interaction (pros and cons)

  • February 5, 2018
  • 2 replies
  • 1342 views

with the AEM 6.3 it looks like now we seem to have a capability wherein using Java/OSGi we can connect to databases such as Oracle/mySql and get the data to AEM environment, which is nice feature.

my questions are

does this adds any overhead to AEM runtime environment in terms of if it reads the data from JCR repo vs external data source such as Oracle?

would it have any negative impact in terms of performance of the AEM services?

does cache of the request dispatcher would be still intact for these kinds of services consumed through AEM.

I was just looking for others pros and cons before head down on this pattern.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by smacdonald2008

AEM has always had the capability to connect to a relational database. This is not a new feature. Will a service that interacts with a relational database impact performance? Like any data related question - this all depends on the size of the result set. If you want the service to work with a very large data set - it may impact performance. If you want to perform SQL updates, etc, then it should not really impact performance. All depends on the size of the data set.

Read this white paper -- https://helpx.adobe.com/content/dam/help/attachments/JCR_DB.pdf

2 replies

smacdonald2008
smacdonald2008Accepted solution
Level 10
February 5, 2018

AEM has always had the capability to connect to a relational database. This is not a new feature. Will a service that interacts with a relational database impact performance? Like any data related question - this all depends on the size of the result set. If you want the service to work with a very large data set - it may impact performance. If you want to perform SQL updates, etc, then it should not really impact performance. All depends on the size of the data set.

Read this white paper -- https://helpx.adobe.com/content/dam/help/attachments/JCR_DB.pdf

    mohanganesh
    mohanganeshAuthor
    Level 2
    February 5, 2018

    @smcdonald2008 thanks for the document; I did not read the entire document in details but section 7 did help me in deciding when to use AEM  JCR versus RDBMS for transactions.  based on the nature of the app content based vs content +trasnaction based will help folks to make the right decision. 

      Terms & ConditionsAccessibility statement

      Loading footer...