asked on

Best programming language to run MySQL queries with?

Hello everyone,

I have a bunch of data in a MySQL database. I want to analyze and get statistics for all the rows. The queries will take long to complete and intense on the database.

The application uses PHP, but I am curious if there is a better way to run the queries than through a PHP script. Is it better to run it from a file in Linux using C/C++ or is the R programming good for this since it is for stats. Just curious. thanks!

bashtech

Thank you for your question. If I may ask what is your intended use for the data stored in your MySQL database. The best way to answer this question, is to first determine what and how you plan to use this data. If your intentions are to use the data in an online scenario. I look forward to your response.

Best Regards,

//bashtech

parlays

ASKER

Thanks for the response.

I want to store the compiled statistics in the database and display them online.

I plan to use PHP to display the data but I'm a little concerned about using it to retrieve and compile the data. Part of the stats will be found through SQL queries alone and the other part of the stats will be compiled from pulling records out of the database and then having the programming language analyze and create the stats.

SOLUTION