Interfacing a large set of data mysql



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!