The latest articles on DEV Community by hirenjariwalatreta (@hirenjariwalatreta). https://dev.to/hirenjariwalatreta https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F392553%2Fb973cfca-e8de-46c8-b0a3-cf4ae10a45b8.png https://dev.to/hirenjariwalatreta en hirenjariwalatreta Mon, 20 Sep 2021 12:53:36 +0000 https://dev.to/hirenjariwalatreta/speed-optimization-508o https://dev.to/hirenjariwalatreta/speed-optimization-508o <p>We have a large application having billions of records stored in the database and we have a global search page that searches items from a large DB repository.</p> <p>We have 120 dynamic filters and 150 fields and user can select anything as he/she wants.</p> <p>Each dynamic field has also multiple options like Is, is not, starts with, ends with, contains, does not contains, is blank, is not blank. Users can select any one from these options.</p> <p>Overall everything is dynamic based on the user’s choice.</p> <p>Our database is MS SQL Server and the front-end application is in .net core in MVC style.</p> <p>We have made a store procedure that executes a query for this but it contains 40 joins and multiple “case when” statements, stuff function that gives results but taking too much time.</p> <p>We need performance optimization for this requirement and the client is asking urgent.</p> <p>Can anybody share the ideas what is the best way to fulfill this requirement and get results quickly?</p> hirenjariwalatreta Fri, 22 May 2020 06:09:31 +0000 https://dev.to/hirenjariwalatreta/issue-related-to-flushsynccallbackqueue-38hd https://dev.to/hirenjariwalatreta/issue-related-to-flushsynccallbackqueue-38hd <p>Hi</p> <p>While development in React JS application, I have faced one issue. Can anybody help to resolve?</p> <p>Issue:<br> I have applied accordion panel with number of accordion items. On first time few of them is expanded by default. There is option on page to expand all and collapse all. I can perform that operation successfully. But after that once click on accordion item to expand, it expand and immediately collapse again due to call of react function flushSyncCallbackQueue() automatically. This function is called from discreteUpdates$1() react function. I want to stop this automatic calling function.</p> <p>Please let me know if someone have solution for that.</p> <p>Thanks</p> issue react stop flushsynccallbackqueue