MySQL Forums
Forum List  »  PHP

Question about phpMyAdmin and statements
Posted by: Michael Pryfogle
Date: August 24, 2005 07:45AM

My current PHP page makes 3 temp tables, then has a select statement that selects from what is in the tables. In my script it takes ~40 seconds to run, almost all of this is the select statement (building the temp tables takes way less than 1 second). When I run the same queries in phpMyAdmin, semicolon seperated, it states it takes less than 1 second and I have a screen full of information in less than 3.

I was wondering why the large difference between the two? I am really looking to speed up my page. I am accessing MySQL as localhost for both.

I'm using
phpMyAdmin 2.6.1-pl2
MySQL 4.1.13-standard
PHP 5.04

Thank you,
Michael

Options: ReplyQuote


Subject
Written By
Posted
Question about phpMyAdmin and statements
August 24, 2005 07:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.