MongoDB-Rox / phpMoAdmin-MongoDB-Admin-Tool-for-PHP

MongoDB administration tool for PHP built on a stripped-down version of the Vork high-performance framework
http://www.phpMoAdmin.com
GNU General Public License v3.0
187 stars 86 forks source link

Paging for collections with large number of records #4

Closed asethi closed 14 years ago

asethi commented 14 years ago

By default all records are loaded and it overwhelms the system/browser if there are too many records.

MongoDB-Rox commented 14 years ago

Thank you for reporting. Pagination is already on the ToDo list (see the Wiki page) so this is not exactly a bug, how many records and of what typical size did it take to overwhelm your browser? Mine does not blink with collections of many hundreds of records, each object being about 20-30 lines long.

asethi commented 14 years ago

Sorry, I didn't see it on the wiki page.

We are planning to store 14 million records in our main collection with approx 25 fields in each. The tests right now of 50k or 100k do overwhelm our systems. Now I use the edit page to view by _id, so it is still useful and we use the main system to view the smaller collections.

The software is excellent BTW

MongoDB-Rox commented 14 years ago

Thank you for the compliment, a lot of effort went into phpMoAdmin. Assuming each field is at least 20-bytes of data (likely more) at 100k rows that is 0.5mb of text on one page, so in your case pagination would certainly be necessary. Would you be interested in contributing that feature to phpMoAdmin? Email me: support |a-t| phpmoadmin.com

MongoDB-Rox commented 14 years ago

Hi, the latest version of phpMoAdmin includes pagination with an adjustable-limit and has been tested to work on a dataset of 300k large objects (averaging 2kb each), please report your experience using phpMoAdmin on your 14m object database. Thank you.