search

GOVTNZ / silverstripe-sqlexplorer

Read-only SQL access in a SilverStripe site
4 stars 0 forks source link

Implement pagination for large table results #1

Open chillu opened 9 years ago

chillu commented 9 years ago

SQLExplorerTable ->getTableData() does an unlimited SELECT * and creates (relatively expensive) ArrayData structures from it, so bound to run out of PHP memory without pagination.

Also, sorry that you have to write this module in the first place - I've seen phpMyAdmin readonly access popping up on some CWP backlog at least :)

mrmorphic commented 9 years ago

Sorry to take a while getting back. Yep, pagination is a good idea.

Even despite the alpha-level of this module, it has been very useful at this end.

M