Bulelani Botman
Bulelani Botman
Explore posts from servers
CC#KPCKevin Powell - Community
PostsComments
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
yes, i can do but with a limited number of records, 20K records max
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
okay, let me run & see what the error name is again so i can confirm
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
i am lost with this one, what does do?
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
i did implement the search feature but on another page it's just not suitable. i need to pull all those records whether i like it or not and the user just can't search because he doesn't know the information / doesn't have the info because this table is just filled with properties that are about 900K
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
yes, i was just telling him that the datatables plugin does pagination for me but my problem is just the connection timeout!
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
the datatable plugin has the pagination feature, if you are pulling lets say 10k records it will automatically do it for you but my issue is behind the scenes which is my SQL code. I am using 
SELECT * FROM LIS
SELECT * FROM LIS
which pulls all the columns and the records from this table and I get the connection timeout from MSSQL Server because pulling a lot of data at once & trying to display it
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
well, thank you for explaining this scenario. it absolutely helped me
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
ohhhh! i will try to use it. so, i assume when you press the next button in the view it will go back to the sql script and laod the next batch?
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
no, i think i will revert back to just searching for the specific data that a user wants & display that record rather than requesting all 900k records
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
is there a sql script for using pagination?
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
ohhh! search before loading the data
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
i did work on this feature, i will try to implement it again on this project
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
no! after the data is fully loaded
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
Raw SQL, I used EF but then i needed to pull from multiple databases so i turned to raw SQL
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
one solution is pagination, how does this work?
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
they will search using an ID & the datatable will filter the records because it has this feature
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
mhhh! maybe export the data to an excel file or so?
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
lmao! i figured it out the hard way
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
Can you redirect me to where I can learn about this
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
It's required for the user to see all these records & choose which ever record they want to use
59 replies