Used structures/datagrid with paging and column sorting to display some mysql database records to a rather experienced programmer at my office, and he immediately asked me two questions I didn't have good answers to:
1) The paging looked good and all, but what about the overhead when the number of records increases from a couple hundred to several thousand? This would be in issue with users in Asia and servers in the US.
2) What about sql injection in the URL? How easy is it to monkey with this?
I'm just an amateur, and now I'm thinking I should just abandon Pear and write it all from scratch, or is that silly?