My Flex app is currently interfacing a mySQL table of about 3Million rows. Flex is used just to view and slice the data; nothing is ever written back to the database.
We just moved from e4x to using amfphp and experienced a good performance increase but still performance is quite slow. Paging or "splitting" is not a real option since the charts and tables on the Flex front are already aggregating.
What do you think is the fastest way for Flex to read a MYsql database? Is amfphp the best method or am I missing a trick? I presume there is a much better way but just need a nudge in the right direction!