Hi, We have been running different flavors of Sequoia in a test environment for the last few months. We have been testing primarily version 3.0 beta 2 which seems to have worked quite well under many of the tests we have put it through.
We recently moved back to testing 2.10.8 after understanding this was was the more stable tree. We have a custom java app that does a database call and creates a CSV report from the returned data. To outline our current setup for testing it is two controllers with two postgresql database nodes attached to each. In version 3.0 beta 2 we have had no problems with running these queries. As of moving to version 2.10.8 we have ran into a significant delay on certain queries. We have put on the debugging on in Postgresql, so we can see the queries. What does work is as follows (when see set our app to use) 3.0beta2 with driver Sequoia Driver=8.10 Postgresql direct with Postgresql driver postgresql-8.2-504.jdbc3 Direct queries via psql Direct queries via Sequoia 3.0beta2 via console cli Direct queries via Sequoia 2.10.8 via console cli What does not work is when we setup our App to use the Sequoia 2.10.8 with Sequoia Driver 8.11 or even using 8.10. There is no exceptions coming out any of the logs, the backends seem to respond quickly under every other circumstance. Response times Using 2.10.8 real 5m46.032s user 0m4.320s sys 0m0.275s Using 3.0Beta2 real 0m36.051s user 0m4.400s sys 0m0.256s This is returning a CSV of 700kb in size. -- Stuart James _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
