600,000 rows on a table

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
vintoICT
User
Posts: 390

600,000 rows on a table

Post by vintoICT »

i have a VPS hosting of
4 GB RAM
Xen Virtualization
75 GB Disk Space
10TB Bandwidth

i am expecting max rows of 600,000 on a table . I have other 3 tables about same rows. and other lesser tables I created 2 views on the table of 600,000 rows. will this work well? especially the views. Thank you .


arbei
User
Posts: 9292

Post by arbei »

Just make sure you set up a reasonable setting of "Records per page" or "Groups per page" (for report). You definitely don't want to load all records at one time.


Post Reply