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 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. 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 ? 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. 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? 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. 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. 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. Link to comment https://forums.phpfreaks.com/topic/164206-how-to-stop-it/#findComment-867481 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.