Performance Issue | Finding Record taking more than 1.2 Seconds with Simple Where Condition #2529
myalgomate
started this conversation in
General
Replies: 1 comment
-
I guess you forget to use an index for this column. Look here: |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
We are finding this record with Linq in C# that is also taking the same time Around >1.2 Sec
so we tried regenerating the where condition with DB viewer with that also we are getting the same delay.
We are using Version [v5.0.17] currently.
SELECT $ FROM Custom_Instrument where InstrumentToken ="867726";
Uploading Sample file
https://filebin.net/ncrc1l4wseq3s7q8#
Total Records: 74,000
How can we decrease the time ..?
Beta Was this translation helpful? Give feedback.
All reactions