Notes searching in Max Ent 5.0 SQL

markhNew Member

We recently upgraded one of our Btrieve 6.15 Max Ent 5.0 databases to Max Ent 5.0 on SQL Server 7.0. All seems to run OK.

However, there appears to be a marked performance impact when searching for notes text, especially against specific date ranges. 25 minutes to return 300 client records from a database of 14,000 clients! Number of rows in notes table is 31312 (nothing excessive).

I have queried the database notes table through Access and it runs almost instantaneously.

Any ideas?

6/21/0112:14 AM

❤️ 0

Original Post

Add Reply

<ul id="{%=id%}ButtonGroup" class="button-group h-popup-buttons even-button-group even-1">
    <li id="{%=id%}Okay_buttonContainer"><a id="{%=id%}Okay" href="javascript:void(0);" class="button success no-margin-bottom h-alert-modal-ok-button" role="button">OK</a><script type="text/javascript">
        (function() {
            function {%=id%}Okay_click(event, data) {
            {%=id%}Popup.hide();
        }
        
                $('#{%=id%}Okay').on('click', {%=id%}Okay_click);
        })();
    </script></li></ul><a href="javascript:void(0);" class="close-reveal-modal" aria-label="Close Modal">&#215;</a><div class="last-modal-focus focus-utility-element" tabindex="0"></div>
</div>
<script type="text/javascript">
        (function() {
            {%=id%}Popup = new SS.Popup.ModalPopup('{%=id%}');
        })();
    </script>

Skip to main content

Add Reply

Membership Required

Remove From Your Block List

Manage Follow Preferences

Block

Please wait...