the query has been canceled because the estimated cost of this query (569) exceeds the configured threshold of 300
-
Dear all, I got this message when i try to select data from table with more than 90201 row. The query has been canceled because the estimated cost of this query (569) exceeds the configured threshold of 300. Contact the system administrator. I got this when i try to show all data in that table in website(aspx page). I just normal user can not log in to change any setting in sql server admin. please help
-
Dear all, I got this message when i try to select data from table with more than 90201 row. The query has been canceled because the estimated cost of this query (569) exceeds the configured threshold of 300. Contact the system administrator. I got this when i try to show all data in that table in website(aspx page). I just normal user can not log in to change any setting in sql server admin. please help
The DB engine is actually doing a great job of protecting you. What are you going to do with 90,000+ records on a web page ? It would be impossible for someone to browse that much data. Change your logic to retrieve "blocks" of data, say 100 records or so. You will need to break the data down into "pages" of data where the user could click on a control and retrieve the next grouping of data. For example you could provide a A through Z filter on the top of the page, the user clicks "M" and you would retrieve the first 100 people with the last name beginning with M. The "Next" button would then fetch the next 100 people with the name beginning with M and so on ... 90,000 records is way too much data to display in a single query. Good luck.
-
The DB engine is actually doing a great job of protecting you. What are you going to do with 90,000+ records on a web page ? It would be impossible for someone to browse that much data. Change your logic to retrieve "blocks" of data, say 100 records or so. You will need to break the data down into "pages" of data where the user could click on a control and retrieve the next grouping of data. For example you could provide a A through Z filter on the top of the page, the user clicks "M" and you would retrieve the first 100 people with the last name beginning with M. The "Next" button would then fetch the next 100 people with the name beginning with M and so on ... 90,000 records is way too much data to display in a single query. Good luck.
Actually that table's name is Tblvisitor, I want to get some more info about my visitors so i display that data in web page (100/page) before it is about 50000 i can display them. but now it is about 100000 so i got error. Yes, your idea is good, now i display only data from 80000 and hide data from 1 to 79999 so it is working again. However thank you!!! good luck.