Please create JIRA for the "select count(*)" case.
As far as the write taking long time, I see BatchPutAttributes - Amazon SimpleDB 25 row limit thus may be taking more time. If you can find an alternative then we can see if we can enhance the code
Thanks. I have created a bug [TEIID-3845] for the SimpleDb connector.
As far as the write issue is concerned that I mentioned in the first portion of my post, that was regarding the Cassandra connector and not the SimpleDb connector. Let me know if the issue needs any further clarification.
Looks like the translator did not implement the Bulk Update feature, so you can add enhancement request for it. However, if know any documentation how this is done with Cassandra please add that to the JIRA. BTW, code contributions are welcomed here.