From a web page, user submits parameters to a perl program which performs multiple queries, then spits the info out formatted for the web.
Does anyone have a quick & dirty method of locating a bottle neck slowing these queries down? I am hitting multiple tables within the same database, all through the same connection. Ie perform Q1, store results, perform Q2, store results, etc.
I am still fairly new to MySQL. I am currently running 4.1 for some advanced features (GROUP_CONCAT).
Any/all suggestions are helpful.
Thanks Patrick
Patrick J. Shoaf, Systems Engineer <mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED]
Midmon Internet Services, LLC 100 Third Street Charleroi, PA 15022 http://www.midmon.com Phone: 724-483-2400 ext. 105 or 888-638-6963 Fax: 724-489-4386
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
