Announcements
No record found.
Dear Friends,
I have a problem:
1/ Optimize system with more than 15 millions serial?. Could you advise it?.
*This post is locked for comments
Could you please provide more details?
Dear Friend,
Please you send your question. I will answer.
Please share more details about the issue that you are facing. I think it's easier that way instead of spending time for quessing these details.
Hi Cuong,
How much memory have you allocated to SQL? Try increasing this maybe
How often do you reindex your DBs?
Do you have Full Text Indexing switched on?
I answer your questions:
1/ How much memory have you allocated to SQL? Try increasing this maybe==>64GB. What's memory I should be?.
How often do you reindex your DBs?==>1 time/1 year
Do you have Full Text Indexing switched on?==>No, I don't.
Try reading this, I think it will help.
docs.microsoft.com/.../full-text-index-overview
Sorry, my customer confirmed that my customer have applied Full Text Indexing but the speed of this system increased 1%.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Joris dG 5
Andrew Jones a1x 2
Basit 1
