Performance issues

Hi, In my local with Postgres i got data back up from production and QA. When i test it on QA it is taking 30 secs time to load the data but in local with the same databack up it didnt take that much time like it is quick. How can i check what could be the issue behind this?   Thank you, Srihitha.
1 answers

How many rows are being returned?  In some cases, if you are returning a large number of rows, the time you will wait is due to communication of those rows to your browser and, if your page is complex, the time it takes your browser to render the page.