3 Replies Latest reply: Jan 19, 2011 12:33 PM by Bill Britt RSS

    databases on the server

    dieyna86

       

      I know that it's recommended to put all the qlikview documents on the qlikview server and my question is:

      The different database (mysql, oracle, excel ... ) to which we connect the application during development should also be on the server so that if we change the level of the database application take into account?



        • databases on the server
          Bill Britt

          Not sure what you mean by "change the level of the database application". Please remember the QlikView server uses a lot of memory and has a working set this it setup with the server when it starts. SQL and Oracle does the same think and this will cause performance issues with the server. QlikView only needs ODBC connections to the SQL Or Oracle servers. The data is only read into QlikView when a document is reloaded.