Reply to thread

Message: [QUOTE="alin, post: 613623"] JSC, I am a jTDS developer; maybe I will be able to help you figure out if jTDS will help you or not. First of all what kind of benchmark did you run? The MS driver has one very serious limitation that should be easily visible in any benchmark: you have to set the selectMethod property to cursor in order to be able to use transactions; in cursor mode the MS driver will open a server side cursor for each SELECT and fetch the rows one by one (a network request is made for each row in part). Running in direct mode (selectMethod=direct) on the other hand, even in the limited situations that it works in, will cache the whole server response into memory (no idea why); a difference in performance should be visible in this case too. Let me know if I can be of any help. Alin. [/QUOTE]