0 Replies Latest reply on Nov 10, 2015 9:38 AM by simone.cossu

    How can I do quick query to database using nsql?

    simone.cossu

      Hi everyone.

      I'm doing some queries to database but I obtain the data after a long time.

      Example,

       

      select * from alert where reviewed = 1

      select * from alert where alertid = 123456

       

      these queries complete after 5 minutes.

      I understand that is related to table indexes (probably these fields are not indexed)

      but there is a workaround? Can I use a database "view" or something similar?

       

      Thank you in advance for any suggestion.

      Simone