SitePoint Sponsor |
|
User Tag List
Results 1 to 6 of 6
Thread: Timeout for queries
-
Feb 19, 2001, 01:00 #1
- Join Date
- Aug 2000
- Location
- Silicon Valley
- Posts
- 2,241
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Anyone knows to stop the execution of a query if it reaches xx secs? like set_time_limit() in PHP.
Thanks- Son Nguyen
AdSpeed.com - Ad Serving and Ad Management Made Easy
-
Feb 20, 2001, 00:58 #2
- Join Date
- Apr 2000
- Location
- Melbourne, Australia
- Posts
- 2,571
- Mentioned
- 2 Post(s)
- Tagged
- 0 Thread(s)
A MySQL query?
Kevin Yank
CTO, sitepoint.com
I wrote: Simply JavaScript | BYO PHP/MySQL | Tech Times | Editize
Baby’s got back—a hard back, that is: The Ultimate CSS Reference
-
Feb 20, 2001, 19:35 #3
- Join Date
- Aug 2000
- Location
- Silicon Valley
- Posts
- 2,241
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Yes, sorry not to mention that.
- Son Nguyen
AdSpeed.com - Ad Serving and Ad Management Made Easy
-
Feb 20, 2001, 19:45 #4
- Join Date
- Apr 2000
- Location
- Melbourne, Australia
- Posts
- 2,571
- Mentioned
- 2 Post(s)
- Tagged
- 0 Thread(s)
Sorry. There is no such facility that I am aware of...
Kevin Yank
CTO, sitepoint.com
I wrote: Simply JavaScript | BYO PHP/MySQL | Tech Times | Editize
Baby’s got back—a hard back, that is: The Ultimate CSS Reference
-
Feb 21, 2001, 16:35 #5
- Join Date
- Aug 2000
- Location
- Silicon Valley
- Posts
- 2,241
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Is it just because MySQL doesn't support or other DB also can't do so?
Since I've seen MySQL "show status" give how many slow queries were done, but how to prevent those (of course, one possible way is to optimize the queries+script)- Son Nguyen
AdSpeed.com - Ad Serving and Ad Management Made Easy
-
Feb 21, 2001, 20:06 #6
- Join Date
- Apr 2000
- Location
- Melbourne, Australia
- Posts
- 2,571
- Mentioned
- 2 Post(s)
- Tagged
- 0 Thread(s)
There is no 'standard' way to abandon a query after a set interval in SQL; however, that doesn't mean that other databases might not implement this feature as a custom extension to the language.
Kevin Yank
CTO, sitepoint.com
I wrote: Simply JavaScript | BYO PHP/MySQL | Tech Times | Editize
Baby’s got back—a hard back, that is: The Ultimate CSS Reference
Bookmarks