I am testing an Android app which sends minute-by-minute updates to my Drupal site which acts as a server.
I create a single node each day and all my app data is saved in CCK fields within that node.
I got the updates working yesterday and tested for half a day. When I try to edit the node, to see the CCK data uploaded, my site crashed and complained of lack of PHP memory.
In my .htaccess file, I had set PHP memory to 100M. I then increased it to 300M and then 500M with no improvements. Then I tried 1000M. It worked but it seems slow.
That's just for one user's half a day's worth of data. Eventually, I will have hundreds of users with 24hours data each.
Can anyone tell me if there is a Drupal distribution which handles heavy data traffic by design?