Iterating through huge number of records inorder to display as HTML or to send to client applications over REST/JSON or SOAP/XML is a huge processing effort for the application server. Read more to know how to delegate such processor intensive work to DB server running MySQL

Read More →