> If you saw my code you saw that the only thing I was doing was a > select statement to the SQL server. The reason the second test was so > fast was because I left caching on, so that I would get a more real > world result.
Ok, I see. > As I said earlier, I have no reason not to use JTDS, as a matter of > fact if they were faster I would be more than willing to use them > instead of Microsoft's drivers. As it stands now though, I have not > been able to justify their use . Even though the tests on your website > show the drivers being faster, it was done in a very specific manner, > I need the drivers to work in a ColdFusion enviroment and if they > aren't faster in ColdFusion then they are no use to me. The tests on the jTDS site (published by a commercial JDBC driver vendor) do just the same: they run a query 100 or 1000 times. > I ask anyone else to run the same test I did. A loop that runs 100 > times is by no means breaking a site, and in my opinion there is no > real reason to bog a server down by running it for hours at a time. > Real world users should be reading from the database significantly > more than they should be doing anything else. I agree with you. However, what I was trying to say was that you were just executing the query and not processing the results. That is not a real world usage, is it? Your testing demonstrates that the Microsoft and DataDirect drivers are faster at dropping data than jTDS. Do some basic processing of the results (like concatenating them in a string or something, without displaying) and you should have something closer to real world usage. Alin. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191783 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
