• DB does not load, or takes more than 2 hours

    By Alex Koppelman 2 decades ago

    Hello!

    First of all, I believe this is one of the best templates on openNTF. It has all a desk would require.



    I have created a database with the template, followed the setup steps, and added some Keywords. However, opening this database freezes the notes client (on different pc's and with different access levels), and does not load. I am updating all the views, and after 30 minutes, I am now at view 8/123, so also not too fast.



    Could there be anything I can do to speed it up? what are your ideas?



    Thanks,

    Alex

    • same here, eternal db load

      By Edwin Casinillo 2 decades ago

      Hi, first of all I really like the project. I'm a noob too in Lotus Notes in general, my company just embraced notes from exchange late last year. Due to pressing requirements I tried to implement this !!!HELP!!! system into our 8.0.1 system. Creating a ticket seems to hang forever.

      • The cause ... maybe

        By Edwin Casinillo 2 decades ago

        Hi guys, I think I know the cause of the eternal DB load …. it's related to the date format as discussed in the other posts. The reason is that these incorrect date formats generates/logs a lot of errors, bloating DB size and causing a huge query response that almost slows down the server and/or client computers. For English, the correct format is mm/dd/yyyy. In my case the database exponentially increased in size to around 8.7GB, from the original of around 14MB only. Now I wonder if Notes could handle efficiently databases of this size, or is this just a matter of optimizing the database queries for this application?