[SOLVED] PHP MySQL vs exec MySQL

[The Little Guy]

would doing a mysql query using exec be faster than doing a mysql query with the built in php functions?

 

So...

 

exec("SELECT * FROM tableName;");

// vs.

mysql_query("SELECT * FROM tableName");

 

Would one excel in speed, or would they do about the same?

[awpti]

Um.

 

exec != mysql_query.

 

That is all.

[The Little Guy]

Um... you can run mysql queries using exec.

[Mchl]

I highly doubt it would be faster.

Besides PHP6 is going to have a dedicated mysql driver which should be even faster.

http://dev.mysql.com/downloads/connector/php-mysqlnd/

[PFMaBiSmAd]

Using exec would be several times slower. Php first has to invoke an instance of the operating system command line processor. The operating system command line processor takes the exec() command line, parses it, and invokes the mysql command line processor. The mysql command line processor parses the sql command(s), formats the low level commands for the mysql server and "calls" the mysql server to execute the commands. Then you must use some slow parsed/tokenized/interpreted php code to parse through the string returned to detect errors or parse through the textual results to get the data into a usable format.

[DarkWater]

Using exec would be several times slower. Php first has to invoke an instance of the operating system command line processor. The operating system command line processor takes the exec() command line, parses it, and invokes the mysql command line processor. The mysql command line processor parses the sql command(s), formats the low level commands for the mysql server and "calls" the mysql server to execute the commands. Then you must use some slow parsed/tokenized/interpreted php code to parse through the string returned to detect errors or parse through the textual results to get the data into a usable format.

 

Yeah, I mean, parsing the results alone would be several times slower than mysql_query.

[The Little Guy]

Thanks guys!