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!