Timeline for How can I cancel all running MySQL queries in a web application?
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S Jul 8, 2016 at 20:19 | history | suggested | Peter Mortensen | CC BY-SA 3.0 |
Copy edited.
|
| Jul 8, 2016 at 17:01 | review | Suggested edits | |||
| S Jul 8, 2016 at 20:19 | |||||
| Jul 25, 2014 at 5:01 | vote | accept | Arun deep | ||
| Jul 10, 2014 at 18:24 | comment | added | Arun deep | Yes, I have indexes set up on that column. Actually I had to make a calculation in that large table by recursively calling it row by row using php script. This is actually slowing the things down.. I have decided to use the stored procedure(though I am new to it) in mysql.. Hope it speed-ens the things up. | |
| Jul 7, 2014 at 13:12 | comment | added | Roman Mik | Consider implementing indexes (as suggested by @Grandmaster). Another approach is to cache previously executed queries so all following requests for the same data are returned from cache. Also, consider implementing pagination and not return all 100,000s records. Canceling a query is too much hassle, and will upset your web users. | |
| Jul 7, 2014 at 7:30 | history | edited | Kilian Foth | CC BY-SA 3.0 |
normalize regional unit
|
| Jul 7, 2014 at 7:03 | review | First posts | |||
| Jul 7, 2014 at 11:40 | |||||
| Jul 7, 2014 at 7:01 | answer | added | Rocklan | timeline score: 1 | |
| Jul 7, 2014 at 6:57 | comment | added | GrandmasterB | Do you have indexes set up on that column to speed up searching? | |
| Jul 7, 2014 at 6:43 | history | asked | Arun deep | CC BY-SA 3.0 |