angel777 Posted June 30, 2009 Share Posted June 30, 2009 hi is there a way to stop a select query while it is processing? My user always felt annoying to wait for the loading process after they selected the wrong search filter combination. i am thinking to allow user to cancel the searching process if they do not want to continue. any help will be greatful Quote Link to comment https://forums.phpfreaks.com/topic/164206-how-to-stop-it/ Share on other sites More sharing options...
corbin Posted June 30, 2009 Share Posted June 30, 2009 Err... You're searching queries shouldn't take that long... And no, there's not a way to cancel a SELECT query.... Well, not gracefully. Quote Link to comment https://forums.phpfreaks.com/topic/164206-how-to-stop-it/#findComment-866208 Share on other sites More sharing options...
angel777 Posted June 30, 2009 Author Share Posted June 30, 2009 hi, my query time actually is fine. what i provides user is the 4 listbox which they are able to filter out the query as they want. However, if user accidentally chooses the value like Select all from Site, select all from customers, select all from employees.. then nightmare comes. how do i stop it ? Quote Link to comment https://forums.phpfreaks.com/topic/164206-how-to-stop-it/#findComment-866212 Share on other sites More sharing options...
fenway Posted June 30, 2009 Share Posted June 30, 2009 I don't see any sample queries, so I have no idea. Quote Link to comment https://forums.phpfreaks.com/topic/164206-how-to-stop-it/#findComment-866664 Share on other sites More sharing options...
Maq Posted June 30, 2009 Share Posted June 30, 2009 hi, my query time actually is fine. what i provides user is the 4 listbox which they are able to filter out the query as they want. However, if user accidentally chooses the value like Select all from Site, select all from customers, select all from employees.. then nightmare comes. how do i stop it ? It's your job to prevent that. Why do you even allow such combinations? Quote Link to comment https://forums.phpfreaks.com/topic/164206-how-to-stop-it/#findComment-866668 Share on other sites More sharing options...
corbin Posted June 30, 2009 Share Posted June 30, 2009 Also, perhaps pagination should be used. Quote Link to comment https://forums.phpfreaks.com/topic/164206-how-to-stop-it/#findComment-866712 Share on other sites More sharing options...
Ken2k7 Posted July 1, 2009 Share Posted July 1, 2009 There is KILL, but I don't know how to tie it into what you're doing. I agree with corbin. You may want to utilize pagination by selecting a limited amount of results per time. Quote Link to comment https://forums.phpfreaks.com/topic/164206-how-to-stop-it/#findComment-866952 Share on other sites More sharing options...
fenway Posted July 2, 2009 Share Posted July 2, 2009 Likewise... set a hard limit on the number of records to be returned, and you're set. Quote Link to comment https://forums.phpfreaks.com/topic/164206-how-to-stop-it/#findComment-867481 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.