[SOLVED] Database error when displaying a huge amount of data

[eluser]rochellecanale[/eluser]
Hello guys just need a little help here my problem is i have a huge amount of data estimated 2 million and 500,000 rows and if i attempt to view this it just loading and display a white page. And if i try to refresh or reload the page it says Unable to select the specified database
How can i view all the data. By the way I'm using a pagination to view this.

[eluser]vitoco[/eluser]
First i guess you have well indexed the tables, second try to increase the amount of memory of the php app with ini_set('memory_limit', 'xxxxM') , and third enable all erros to see what's the exact reason why it shows a blank page.

[eluser]rochellecanale[/eluser]
Thanks for the reply. I solved my problem. I just need to replace a single code in my controller.