Highlighted

Interfacing a large set of data mysql

svekaria

29-08-2008

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!