On Thu, Jan 17, 2002 at 08:27:40PM -0500, Jon Shoberg wrote: > > Well, > > Another app was launched on my mySQL server. Only this one is poorly > coded and heavily used.
That sucks. :-( > Is there a way to change the priority of my connection? My entire > app consists of select statements. Once I changed everything to > "SELECT HIGH_PRIORITY ...", that helped a ton. Can I bump my db > connection higher? Other than what you've done, nothing else comes to mind. Any chance you can add indexes on the tables which may help the poorly coded app? Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 15 days, processed 354,021,062 queries (267/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php