Re: Limitation in number of records when using CakeAMF
Hi kiang, At first I thought you were insane, because I was returning 1000 rows in an array and all was fine... except then I tried with longer data, and got the same problem as you experience. So I did some debugging and have found the solution! Cake was always returning 0 as the length of the data, but that was not a problem for requests under 8000 bytes. It was only when it hit 8001 or higher that cake didn't accept the response. So it turns out to be a bug, the length being calculated from the wrong stream, so always being set to 0! I've added a patch that fixes the problem. https://trac.cakefoundation.org/amf/attachment/ticket/14/cakeamf_fix_length_bug.patch Hope that helps. Cheers, Adam kiang wrote: When working with CakeAMF, I found once the records transfered reached about 60 (9 int columns, 5 varchar columns, 3 datetime columns) or 567 (Only with one ID column), flash can't get the data. I don't know if the limitation came from flash or CakeAMF, but it didn't happened when using amfphp. Although I could divide the data into smaller pieces and fetch them in more than one connection, I still would like to know why and how to resolve it. I've reported it as bug here: https://trac.cakefoundation.org/amf/ticket/14 Environments: Ubuntu 8.10 desktop with latest PHP,MySQL and Apache in repository. CakePHP, svn #7899 Flex 3 application --- kiang --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Limitation in number of records when using CakeAMF
Thanks for your patch. After applying it to plugins/amf/views/amf.php, the flash could get more data now. :) --- kiang On 12月11日, 下午5時10分, Adam Royle [EMAIL PROTECTED] wrote: Hi kiang, At first I thought you were insane, because I was returning 1000 rows in an array and all was fine... except then I tried with longer data, and got the same problem as you experience. So I did some debugging and have found the solution! Cake was always returning 0 as the length of the data, but that was not a problem for requests under 8000 bytes. It was only when it hit 8001 or higher that cake didn't accept the response. So it turns out to be a bug, the length being calculated from the wrong stream, so always being set to 0! I've added a patch that fixes the problem. https://trac.cakefoundation.org/amf/attachment/ticket/14/cakeamf_fix_... Hope that helps. Cheers, Adam kiang wrote: When working with CakeAMF, I found once the records transfered reached about 60 (9 int columns, 5 varchar columns, 3 datetime columns) or 567 (Only with one ID column), flash can't get the data. I don't know if the limitation came from flash or CakeAMF, but it didn't happened when using amfphp. Although I could divide the data into smaller pieces and fetch them in more than one connection, I still would like to know why and how to resolve it. I've reported it as bug here: https://trac.cakefoundation.org/amf/ticket/14 Environments: Ubuntu 8.10 desktop with latest PHP,MySQL and Apache in repository. CakePHP, svn #7899 Flex 3 application --- kiang --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Limitation in number of records when using CakeAMF
When working with CakeAMF, I found once the records transfered reached about 60 (9 int columns, 5 varchar columns, 3 datetime columns) or 567 (Only with one ID column), flash can't get the data. I don't know if the limitation came from flash or CakeAMF, but it didn't happened when using amfphp. Although I could divide the data into smaller pieces and fetch them in more than one connection, I still would like to know why and how to resolve it. I've reported it as bug here: https://trac.cakefoundation.org/amf/ticket/14 Environments: Ubuntu 8.10 desktop with latest PHP,MySQL and Apache in repository. CakePHP, svn #7899 Flex 3 application --- kiang --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
